Thanks! Actually, I had already tried that formula (or something very
similar), but foolishly had not tried it array-entered!
"Max" wrote:
One way ..
Try in say B1, array-entered (CTRL+SHIFT+ENTER):
=AVERAGE(IF(ISNUMBER(A1:A5),A1:A5))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"rmellison" wrote in message
...
I have a column of data, some of which are #N/A. In the next column I want
to
calculate te running average of 5 points in that data. The problem is that
if
any one of those 5 points is #N/A, my running average value is also #N/A.
Can
anyone suggest a formula that will exclude a value in my average
caluculation
if it is #N/A?
Thanks in advance.