Summing a Range Omitting the Occasional #N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can SUMPRODUCT be made to ignore text 6
need formula to add two different criteria in a range 6
Concatenation Setback 4
Need Help with "SUM" AND "ABS" in same formula 12
IF AND Nested Functions - Formula Not Working 0
Summing part of an Alpha Numeric String 2
Summing a range within a range 3
Sum every Nth Row (almost working) 1

Back
Top