Summing a Range Omitting the Occasional #N/A

A

Arturo

How would I go about summing a range that has the occasional Error in that
range?
Appreciatively,
Arturo
 
D

Dave Peterson

One way:

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

RagDyeR

Try this:

=SUMIF(A1:A10,"<>#N/A")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

How would I go about summing a range that has the occasional Error in that
range?
Appreciatively,
Arturo
 
Top