What does the IF formula look like?

I'll bet the result of your IF formula is TEXT. Does it look something like
this:

=IF(A1100,"100","0")

Notice the quotes around the numeric values. That means they're TEXT values
not numeric values and a SUM function would ignore those values.

If you have quotes around numeric values in your IF formula remove them:

=IF(A1100,100,0)

--
Biff
Microsoft Excel MVP


"Christina" wrote in message
...
I'm trying to sum up a column but one of the cells in the sum range has an
IF
formula in it. I need the total sum to include the value of this cell.
When I
do the simple sum formula it doesn't include it in the total. How do I get
this to work for me??

Thanks!