Help with averages. Please!

  • Thread starter Thread starter vamartha
  • Start date Start date
V

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
 
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
 
Back
Top