That makes alot of sense. Thank you!

"Ron Rosenfeld" wrote:

On Thu, 15 Nov 2007 12:07:00 -0800, Christina
wrote:

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


As was pointed out by many, when your IF formula is returning TEXT rather than
a number.

If you enclose a value within double quotes, that value is TEXT, and not a
NUMBER.

SUM function ignores TEXT, so will not add it.

If you want the result of your IF function to be treated as a number, you must
have it return a number. e.g.:

=IF(E280,25,IF ...)


--ron