excluding #N/A

S

sydolly

Hi All,


I am trying to count/sum add the numbers in 1 column however as it is a
column with formulas the '#N/A' result appears and no total can be
displayed?

any takers to resolve this issue?

thanks
 
D

Dave Peterson

How about:

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