Excel How to average last 10 (non-blank) entries in Excel

B

Betsy

Joined
Jul 13, 2005
Messages
2
Reaction score
0
I am using an Excel spread sheet to record the golf scores of multiple players and would like to average the last ten non-blank entries.

Can anyone help?
Betsy
 
You should be able to add a formula to a cell such as:

=AVERAGE(A1:A10)

That will give you the average from cells A1 to A10, even with blanks :)
 
Hi Ian,
Thanks for the reply but I am looking for more than a simple average. Let me explain. My spreadsheet records the date and daily score for numerous golfers. Any golfer that does not play on a particular date will have a blank record. Each player has dozens of entries and I want to automatically average the last ten entries for each player.
Can you help?
Betsy
 
Ah, I see Betsy - I think the only way to do that would be to use VB Script in Excel - I will have a think and see it would be done, or think of an easier way.
 
Back
Top