-------------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
