Sounds like the IF has a problem because its value should be included in SUM
Show us the IF formula
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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!