Quote:
Originally Posted by mrhasan
-------------A------------B--------------C-------------D------------E
1----------1000----------1500----------500-----------X---------- NULL
2----------1000----------1250----------250----------NULL----------X
3----------1000----------1500----------500----------NULL----------X
4-------------------------------------------------------500----------750
Formula for column D4 =SUMIF(D1: D3,"X",C1:C3) [select the space, it was become  so I had to put in the space)
Formula for column E4 =SUMIF(E1:E3,"X",C1:C3)
Whatever you put in the braces must match exactly with the string you are using (X in here) or else it won't work. HTH  |
THANK YOU!!! I was so close! I was screwing doing it like this:
Formula for column E4 =SUMIF(
C1:
C3,"X",
E1:
E3)