Summing all except text

  • Thread starter Thread starter guile
  • Start date Start date
G

guile

Suppose that I want to sum up the value of all numbers in a range o
cells, several of those cells include text, how can I ignore text an
compute all the numbers.

Example

A B C D E F
1 3 5 N N 6 (Formul
Here)

HOw can I add the contents of A1 - E1 (in F1) ignoring NA...

Thanks in advance..
 
=sum(a1:E1)
will ignore text--but not errors.

=sum(if(isnumber(a1:e1),a1:e1))
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.)

This will ignore any errors (and other text, too).
 
Back
Top