Hi!

The SUM() function will ignore text so if you are using a formula that
returns formula blanks ("") it should work.

Is your sum function actually just something like this:

=A1+A2+A3+A4 ???

A formula like that above will return an error if there are text entries in
the range(which is what formula blanks are - TEXT)

If, as you say, you can't change it then a possible work around is to have
your other formula return zero and use conditional formatting to hide the
zero. Just set the font color to be the same as the fill color if the cell
value equals zero.

Biff

"Brad Stevenson" wrote in message
...
I am trying to format an IF function to relay information from one cell to
the other. If I use the value of 0 (zero) in the "true if false" portion
of my function, then my SUM function for the row works fine... but I want
the cell to be blank if there is no info to relay. However, when I use the
"" for blank, then I get the #value figure in my SUM function.

The SUM function is from a worksheet which was formatted by someone else,
and I cannot change it. Is there a way to change the IF function to
perform a cell blank if false, but not to put the #value in my SUM
function?

Thks.