#N/A in the sum total

B

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
 
M

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
 
B

bj

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