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

Help With VLOOKUP 2
Word for Android background colors? (corrected) 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
Multiple Columns in Sum Range using SUMIFS 1
wdActiveEndSectionNumber 1
complicated lookups? 1
#DIV error 2
Adding a big matrix in Word 2013 5

Top