sum Function

[Peg Kavanagh]

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 set up a spreadsheet. I attached an example with just one column. I want the total to show for the ELEC/HEAT column.

[#2]

Peg,

you formula in H2 results in text. And text is ignored by SUM().

=IF(B2="DEPOSIT",30,"")

[#3]

So does that mean I can't I can't get a total of the column? Is there a way to do it?

[#4]

Peg,

I suggest you read my last posting again and again and again ...

[#5]

Wow. Nice response. Not helpful. I'll go elsewhere.

[#6]

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