#N/A and SUM
 

I have a table with numbers and #N/A.

5
10
#N/A
13
etc...

when I try to sum all the numbers up I also get a #N/A.
Is there a way Excel will sum all the numbers and disregard the #N/A?

#N/A and SUM
 

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

amirstal wrote:

I have a table with numbers and #N/A.

5
10
#N/A
13
etc...

when I try to sum all the numbers up I also get a #N/A.
Is there a way Excel will sum all the numbers and disregard the #N/A?

--

Dave Peterson

#N/A and SUM
 

one mo

=SUMIF(A1:A10,"<#n/a")

If your errors are only #n/a's.

amirstal wrote:

I have a table with numbers and #N/A.

5
10
#N/A
13
etc...

when I try to sum all the numbers up I also get a #N/A.
Is there a way Excel will sum all the numbers and disregard the #N/A?

--

Dave Peterson

#N/A and SUM
 

Thanks very much!