Thread: Summing it up
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default Summing it up

"Violet 1" wrote:
I am trying to add up a column that has conditional
formulas and all I get is "0" for the total ...
how do I do this?


What are you doing now? And why do you think zero is the wrong result?
Hint: post some of the conditional formulas, as well as the formula "to add
up" the column.

If your conditional formulas are of the following form (e.g. in A1 and A2):

=if(condition, "123", "")
=if(condition, "456", "")

and you see 123 and 456 in those cell, =A1+A2 would result in the sum (579),
but =SUM(A1:A2) would result in zero.

In this case, the root cause would be that you are returning text ("123")
instead of numbers (123).

Whether or not that has anything to do with your problem is wild speculation.