#N/A Question

E

Ed S

I know why I get #N/A but I am trying to find out how I can sum multiple cells when one or more have #N/A in them.

Right now if I have one cell with #N/A in it and the value in the other cells the total sum results with #N/A

Thanks in advance for your assistance.
 
S

Shane Devenshire

Hi,

Try the following array formula:

=SUM(IF(ISNUMBER(B1:B12),B1:B12,0))

To make it an array press Shift+Ctrl+Enter to enter it.
 
D

Dave Peterson

If you can have any error:
=SUMIF(A:A,"<10E37")
10E37 is a huge number in scientific notation.

or if you only have #N/A errors:
=SUMIF(A:A,"<>#n/a")
 

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

Combination of values targeting a result. 1
VLOOKUP forumla for Excel HELP! 1
Sum Product Quandry 9
Conditional Formatting 1
Try to be more precise 4
help with changing sumif to sumproduct 2
#N/A In Cells 7
VLOOKUP bug? Different answer for values vs calculated table. 2

Top