To sum a range housing #N/A's and numbers, try:

=SUMIF(Range,"<#N/A")

claytorm wrote:
Hi,

I have a string of IF conditions, which I am combining with SUM. I want
to get the IF conditions to ignore any cells containg the error message
#N/A. How can I do this?

Thanks,
Bertie.