The problem appears to be that when you have a 1 in F24, you are
attempting to add a string (in F22) to a number (in F24).

You can get around this problem with the following formula in F26

=IF(F24="","",IF(F22 = "",0,F22)+F24)

Hope this helps.

Martin


http://homepage.ntlworld.com/martin.rice1/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532360