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