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.
