Averages excluding #N/A

R

rmellison

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.
 
M

Max

One way ..

Try in say B1, array-entered (CTRL+SHIFT+ENTER):

=AVERAGE(IF(ISNUMBER(A1:A5),A1:A5))
 
R

rmellison

Thanks! Actually, I had already tried that formula (or something very
similar), but foolishly had not tried it array-entered!
 
Top