Are there/will there be any empty cells within the range? For example:

A2 = 77
A3
A4 = 82
A5 = 83
A6 = 80
A7
A8
A9 = 79

The average would include 77, 79, 80, 82.

What should happen if there aren't at least 5 scores?

--
Biff
Microsoft Excel MVP


"houndawg" wrote in message
...
I'm trying to figure out a way to make an excel spreadsheet that will help
me
out with my players golf scores. I'd like a spreadsheet that I can enter
scores in for each player daily, but will only give me an average for the
lowest 4 out of their most recent 5 scores. I'd like to have their older
scores still visible on the spreadsheet, but not used in the calculation
of
their average. In case I'm as confusing as I figure I am, here's an
example:

Say Billy turns in 6 practice scores, I'd like the spreadsheet to have all
7
scores on it, but only give me an average of the 4 lowest scores he's
turned
in out of his latest 5 scores....ignoring his first two scores.