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

Betsy · Betsy's Computer Specifications

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

**Ian** · Ian's Computer Specifications

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

Betsy · Betsy's Computer Specifications

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

**Ian** · Ian's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel: average range of cells including zeros and excluding blank across sheets	Netskie	General Software	0	6th Dec 2010 11:05 PM
How to caluculate average in excel including blank cells	result	Microsoft Excel Worksheet Functions	3	16th Oct 2008 08:32 PM
Formula to Average non-numeric entries and skip if blank, and more	Ace Fekay [MVP]	Microsoft Excel Discussion	13	16th Apr 2008 03:44 AM
Average Formula to display blank cell if named range is blank	Rachael F	Microsoft Excel Worksheet Functions	3	22nd Feb 2008 05:05 PM
in a pivot table, can the average include blank entries?	=?Utf-8?B?QWFyb24=?=	Microsoft Excel Misc	0	3rd Mar 2006 07:14 PM