Averages excluding #N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
One way ..

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

=AVERAGE(IF(ISNUMBER(A1:A5),A1:A5))
 
Thanks! Actually, I had already tried that formula (or something very
similar), but foolishly had not tried it array-entered!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging with #N/A Cells 4
Calculate rolling average using last 30 values greater than 0. 3
Average formula multiple worksheets 1
Average function 9
Conditional SUMmations and averages 9
RANK based on result and average 5
Variable range column summation and averaging 2
Receiving #VALUE! error for my average formula 2

Back
Top