Anyone know spreadsheet formulas?

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