Here's the formula I'm using:

=IF(E280,"25",IF(E28=0,-))

The formula is doing exactly what it should. I just want the 25 added into
the sum when applicable.

Thanks!
Christina

"Christina" wrote:

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!