Anyone know spreadsheet formulas?

[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