SUMIF formula to ignore #N/A

[walt1122]

Hi All I believe Juan Pablo posed a quick little diddy on how to have the SUMIF ignore #N/A?? I promised myself I would remember it but here I am asking if anyone remembers it or know how to have Excel add up a column even though the column contains #N/A's.

thanks

Walt

 

[Catherine1984]

Hiya

Thanks for responding!

Ive used this formula but its still not giving me the right result

=SUMPRODUCT(--('SALES 2009'!T4:T116=F1),--('SALES 2009'!AB4:AB116<>"to be invoiced"),'SALES 2009'!R4:R116)

TO BE INVOICED is in column AB, so i dont want the formula to count any of these sales, but when i change your formula to AB i get a 0 result, which i know i not the case - am i still doing something wrong here???