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