Formula help

Good day,

I would like to set up a spreadsheet to keep track of bridge scores and 
determine averages through out the year.

There will be a game each week of the year. The total reached that week 
will need to be added to the previous score(s) and an average determined.
Some players may not be present for each week, so I would want their 
average to reflect only the games played and not the games missed.

What formula(s) would I use to determine this average?

Examples of scores could be:
1570, 2250, 1990, not present?(0),4750,6830.

This would represent an average of 3478 (17,390/5).

Thanks for your help.

David

lemoto wrote:
> David:
>> The total reached that week 
>> will need to be added to the previous score(s) and an average
determined.
>>
> Is the total actually needed?
> Or just the average?
I am after the average score.
The problem I am having is how to determine the average score when 
players do not show up for each game. To keep it fair for everyone 
playing, the averages are based on the number of games an individual 
plays, not on the amount of games that are available to play in the year.
Looking back on my records for last year, I had some players who 
attended every game and others who only attended 20 or 7 games. All the 
averages are based on the amount of games a participant plays.

D

David:
> The total reached that week 
> will need to be added to the previous score(s) and an average determined.
>
Is the total actually needed?
Or just the average?
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

David:
> The problem I am having is how to determine the average score when 
> players do not show up for each game.
>
Then: check out PUREAVG().
Be sure of the conditions in which a cell is ignored.

Of course you can calculate @AVG() also, if you wish.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

lemoto wrote:
> David:
>> The problem I am having is how to determine the average score when 
>> players do not show up for each game.
>>
> Then: check out PUREAVG().
> Be sure of the conditions in which a cell is ignored.
> 
> Of course you can calculate @AVG() also, if you wish.
PUREAVG did the trick. I place a simple n/a in a cell when individuals 
are not there or leave it blank and it works well. Thank you.