Average For Variable-length Column (w N/A value inside)
 

Hi,

I have this column which stores variable data and connected to a chart
Some of the data has N/A value on it. If I take the average of th
whole set of data it gives me error value (Perhaps, due to the dat
with N/A value). If the solution is to take away the N/A value fro
the data the trend on the chart will be discontinued. So I would lik
to get the average of non-error values only without deleting the N/
values.

BR,
Joh

--
Billabon
-----------------------------------------------------------------------
Billabong's Profile: http://www.excelforum.com/member.php...fo&userid=1090
View this thread: http://www.excelforum.com/showthread.php?threadid=26597

Average For Variable-length Column (w N/A value inside)
 

=Average(if(isnumber(A1:A10),A1:A10))

Entered with Ctrl+shift+Enter rather than just enter since this is an array
formula.

--
Regards,
Tom Ogilvy

"Billabong" wrote in message
...

Hi,

I have this column which stores variable data and connected to a chart.
Some of the data has N/A value on it. If I take the average of the
whole set of data it gives me error value (Perhaps, due to the data
with N/A value). If the solution is to take away the N/A value from
the data the trend on the chart will be discontinued. So I would like
to get the average of non-error values only without deleting the N/A
values.

BR,
John


--
Billabong
------------------------------------------------------------------------
Billabong's Profile:
http://www.excelforum.com/member.php...o&userid=10904
View this thread: http://www.excelforum.com/showthread...hreadid=265971