#N/A Question

  • Thread starter Thread starter Ed S
  • Start date Start date
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.
 
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.
 
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")
 
Back
Top