How to limit sum function to numeric values

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

Guest

How do I add a group of cells but ignore any cell with a value of "na"?

Thanks
 
Thanks...

How do I handle a situation where I want to add non-consecutive cells, such
as A1+A5+A12....
 
In that case, it would probably be easier to eliminate the #N/A errors rather
than trying to SUM around them.

Do something like:

=IF(ISNA(your formula),"",your formula)

This way, if your formula results in #N/A, a blank will be returned instead.
Then, the SUM function will work on those cells. SUM(A1,A5,A12)

HTH,
Elkar
 
Understood - but the total is adding subtotals in a sense....currently done
by +sum(a1+a4+a7) etc...
 
=SUM(A1,A4,A7)

will ignore text but not errors


--


Regards,


Peo Sjoblom
 
True, but not error values if the OP had #N/A from for instance a VLOOKUP


--


Regards,


Peo Sjoblom
 
Yes. I was assuming that the OP knew the difference between "na" and #N/A or NA().
 
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

SUM and IF functions 2
Array Function to do a Sum of VLookUps that translate a letter gra 3
Sum data range containing NA() 1
Set add function ignore #N/A 1
date formulas 9
Summing rows using formulas with variables 1
Hope this is easy 3
Can i get a sum function to recognise X (letter) as a number? 6

Back
Top