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.
 

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

Excel Excel conundrum - I've tried and tried, but 10
Finding Average of last 5 entries 11
Excel Average dates help 0
Moving Average with Blanks 3
Average from first non-blank cell 12
Average of last 3 non-0 numbers in row? 2
Help With A Golf League 4
played win percentage for averages for a league. 1

Back
Top