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

[Billabong]

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

 

[Tom Ogilvy]

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

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