sum Function

Question

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.

detlef_lewin · Answer

Peg,&nbsp;you formula in H2 results in text. And text is ignored by SUM().=IF(B2="DEPOSIT",30,"")

peg kavanagh · Answer

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

detlef_lewin · Answer

Peg,&nbsp;I suggest you read my last posting again and again and again ...&nbsp;

peg kavanagh · Answer

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

yury tokarev · Answer

Hi Peg,&nbsp;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.&nbsp;Please see attached the adjusted file&nbsp;Hope this helps&nbsp;

Forum Discussion

sum Function

5 Replies