Help with averages. Please!

[vamartha]

I am working on a spreadsheet, and want to average scores within a month
at any given time. Here are the variables:

1) The scores are listed in every third cell (first cell is date,
second is score and third is who scored it - repeating thru 21 scores)
((this is a call center spreadsheet))

2) There will only be scores in some of the dates, others will not be
filled in yet so I want it to average only what is filled in and ignore
what is not

3) I have to duplicate this formula for 148 employees, with about 15 -
20 per worksheet.

I'm an Excel newbie - older than dirt - computers were enclosed in
entire rooms when I was last in school, so to have gotten as far as I
have with the workbook, I am proud of myself. However formulas kick my
butt when trying to work out. Any help will be greatly appreciated.

Thanks

 

[Peo Sjoblom]

One possible way assuming that the list starts in A2 with a date, then
score, then name,
adapt accordingly to fit

=SUM((MOD(ROW(A2:A50),3)=0)*IF(ISNUMBER(A2:A50),A2:A50))/(COUNT(A2:A50)/2)

entered with ctrl + shift & enter