=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