Keeping a running average in Excel ?

G

Guest

I have a series of cells in a row that calculates an average from the two
cells above it. Example, cell A1 is number of workdays, cell A2 is total
number of inspections. Cell A3 is the average number of inspections per day.
A3 is the formula A2/A1. Cells A3 through BC3 have that formula. Cell BD3 I
would like to be a running average. But because there are zeros in a lot of
the row 3 cells since the data above them has not been entered yet, BD3
includes those zeros in its average. I want to be able to keep a running
average in BD3 that updates as the cells update. I'm building this for others
so I don't want them to have to try and create the formula.
 
G

Guest

please disregard this question. I looked a bit farther down and found the
same question and the solution.
thanks
 

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

Average formula 2
Average formula where blank cells are counted as zeros 4
average in non-continuous set, excluding blanks 6
Average Function that ignores zeros 10
Excel Average dates help 0
countifs Function not giving desired result with date criteria 2
#DIV error 2
Trying to find additional ranges outside of min, max, and average 2

Top