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.