Summing a Range Omitting the Occasional #N/A
 

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

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

Arturo wrote:

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

--

Dave Peterson

Try this:

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

--

HTH,

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

"Arturo" wrote in message
...
How would I go about summing a range that has the occasional Error in that
range?
Appreciatively,
Arturo