Forum Discussion
sum Function
Setting up a spreadsheet, have columns with formulas that will automatically pop in specific numbers. I can't get those columns to give me total (sum). What am I doing wrong. Been too long since I've...
Peg,
you formula in H2 results in text. And text is ignored by SUM().
=IF(B2="DEPOSIT",30,"")
So does that mean I can't I can't get a total of the column? Is there a way to do it?
Peg,
I suggest you read my last posting again and again and again ...
- Wow. Nice response. Not helpful. I'll go elsewhere.
Hi Peg,
your formula in H5 being =IF(B5="DEPOSIT","$30.00", " ") shows 30 as text, because it is encircled with quotation marks. This is why your sum formula at the bottom cannot pick up 30 (bacause it thinks that it is a text). If you remove the quotation marks and the dollar sign, the sum formula at the bottom will work. Please replace the formula in the H5 cell with "=IF(B5="DEPOSIT",30, " "), with is the same as Detlef correctly mentioned, and copy it accross to the entire column to make it consistent.
Please see attached the adjusted file
Hope this helps
