Sum with #N/A

K

Kevin

How can I sum a list of cells while ignoring those cells
with a "#N/A" as a value?

The #N/A is from a Vlookup I am doing, and sometimes a
#N/A will occur.

Thank you.
 
F

Frank Kabel

Hi
one way: change your VLOOKUP formula to
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
and use SUM

or use
=SUMIF(A1:A100,"<>#NA")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set add function ignore #N/A 1
#N/A In Cells 7
sum on multiple worksheets 0
Sum ignoring cells with error 1
Help With VLOOKUP 2
Sum the results of a vlookup 6
Sum and "N/A" 3
Use & with two formulas 2

Top