Aladin Akyurek Wrote:
Also...

=SUMIF(K10:K30,"<#N/A")

would ignore #N/A's.

Ah yes! Keep forgetting about that one. :)


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=274269