Anyone know spreadsheet formulas?

[Myka]

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)

[mrhasan]

Originally Posted by Myka

THANK YOU!!! I was so close! I was screwing doing it like this:

Formula for column E4 =SUMIF(C1:C3,"X",E1:E3)

Glad I could be of help

The same thing can be achieved by various other functions. Lookup is another one they gives you more flexibility but can get a bit complicated so if you like, you can try lookup too. Youtube has great tutorials.

[Myka]

Originally Posted by mrhasan

Glad I could be of help

The same thing can be achieved by various other functions. Lookup is another one they gives you more flexibility but can get a bit complicated so if you like, you can try lookup too. Youtube has great tutorials.

I don't have the patience for YouTube tutorials, but I was Googling formulas. I couldn't make sense of it properly, and figured I'd ask here and see if I got an answer before I managed to figure it out. You won.

[mrhasan]

Originally Posted by Myka

I don't have the patience for YouTube tutorials, but I was Googling formulas. I couldn't make sense of it properly, and figured I'd ask here and see if I got an answer before I managed to figure it out. You won.

Yay. I love winning Thanks for giving the chance