#N/A and SUM

[amirstal]

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]

=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.)

 

[Dave Peterson]

one more:

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

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

 

[amirstal]

Thanks very much!