Great solutions, Benjie. May I suggest the OP use the ISNA function
instead of ISERROR? ISNA will only ignore the error caused by the
#N/A, where ISERROR will ignore ALL errors, regardless of the cause and
may hide problems elsewhere in the data.

=if(isna(A+B+C+D),A+C+D,A+B+C+D)

I have seen both Ron deBruin and Dave Peterson make this observation.

Cheers!

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=391362