#N/A in the sum total

[BGN]

Is there a way to ignore #n/a in the sum function? Here is what I a
trying to do. I matched cost and revenue of 2000 machines by usin
vlookup function. There are some unmatched revenue and unmatched cos
items. I want to know how much cost I was able to match and see wha
portion is unmatched.

Right now, I am sorting all the N/As and then using the sum functio
for the rest. I need to resort if I want to get the detail by model.


Thanks for your help.

BG

 

[maxhugen]

Just a suggestion: would the SUMIF function help?

Perhaps if it's used together with the ISERROR function, it will ignore
the errors and sum the rest?


HTH

 

[bj]

use the subtotal command for the entire list and then use
an autofilter for the list to be not equal to "#n/a"

 

[Aladin Akyurek]

Just

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

will do.