Hi,

Then I think you have a couple of issues. Changing 0 to "" evaluates as
false and because you get a value error then some or all of your numbers in
P2 etc seem to be text. Try this for each of those cells

=isnumber(P2) and each should evaluate as true. If any evaluate as false
then they are text.

second consider AB2 is it really <0 or is there a small number that the
formatting of your formula cell or of AB2 stops you from seeing.

Mike

"mickey" wrote:

I'm getting a blank cell. The cells are all formatted as accounting. If I
change the formula from a 0 to "" I do get the #VALUE! error.

"Mike H" wrote:

Hi,

There's nothing wrong with the formula so if AB20 evaluates as false then
it will sum the 4 cells providing they are numbers but if any are text you
will get a #VALUE! error. What error are you getting?

Mike

"mickey" wrote:

I am reading values from several worksheets that are compiling on a front
worksheet. However, when I try to sum those values my formula is not
recognizing the later cell values.
=IF(AB20,AB2,P2+S2+V2+Y2)
Anyone experience this and how did you resolve it?
By the way, I'm running Excel 07.
Thanks