excluding #N/A
 

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


--
sydolly
------------------------------------------------------------------------
sydolly's Profile: http://www.excelforum.com/member.php...o&userid=27128
View this thread: http://www.excelforum.com/showthread...hreadid=466960

=if(isna(myformula),"",myformula)
************
Anne Troy
www.OfficeArticles.com

"sydolly" wrote in
message ...

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


--
sydolly
------------------------------------------------------------------------
sydolly's Profile:
http://www.excelforum.com/member.php...o&userid=27128
View this thread: http://www.excelforum.com/showthread...hreadid=466960

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

sydolly wrote:

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

--
sydolly
------------------------------------------------------------------------
sydolly's Profile: http://www.excelforum.com/member.php...o&userid=27128
View this thread: http://www.excelforum.com/showthread...hreadid=466960

--

Dave Peterson