If I understand your problem correctly, then here what you may want to
do.

You use an IF statement in A2, but not in A3. Put the following in
A3:

=if(iserror(sum(...),"",(sum(...)))

If you don't know what iserror does, look it up in the help. But for
understanding, it tells you whether there is an error or not and the
asnwer it gives if either TRUE or FALSE.

sum(...) is your sum function that you have in A3 now.

Hope that helps.
Proper


--
proper
------------------------------------------------------------------------
proper's Profile: http://www.excelforum.com/member.php...o&userid=33166
View this thread: http://www.excelforum.com/showthread...hreadid=537382