As Kevin says, it's probably better to eliminate #N/A at source. Do you
only have #N/A in column I, what formula do you have in I?

An alternative is to use a formula like

=SUM(IF(ISNUMBER($I$7:$I$2585),($I$7:$I$2585=921)* ($L$7:$L$2585="Fb")*(AS7:AS2585)))

confirmed with CTRL+SHIFT+ENTER


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=510776