PraveshG81
New member
- Joined
- Oct 6, 2011
- Messages
- 22
- Reaction score
- 0
- Points
- 0
Hello,
In column D (of the Results tab) I am trying to sum the values of the first 3 columns only when the first 3 columns are not empty. As you will note, the first 3 columns in this tab (Results) have Offset/Match formulas.
The point of the Results tab is that when i export the data into the Raw tab, the column order can possibly change. Thus, i use the offset/match function in the Results tab to find information for a specific column regardless of where it is located in the Raw tab.
Can someone tell me why my formula of =IF(AND(A2="",B2="",C2=""),"",A2+B2+C2) gives me a #VALUE whenever Column A, B, C (in Results tab), have a value? It should simply be adding the columns and giving me a total!
Thanks for your help!
In column D (of the Results tab) I am trying to sum the values of the first 3 columns only when the first 3 columns are not empty. As you will note, the first 3 columns in this tab (Results) have Offset/Match formulas.
The point of the Results tab is that when i export the data into the Raw tab, the column order can possibly change. Thus, i use the offset/match function in the Results tab to find information for a specific column regardless of where it is located in the Raw tab.
Can someone tell me why my formula of =IF(AND(A2="",B2="",C2=""),"",A2+B2+C2) gives me a #VALUE whenever Column A, B, C (in Results tab), have a value? It should simply be adding the columns and giving me a total!
Thanks for your help!