lwlskop's blog
Calculate a list of Averages from a Timesheet
Submitted by lwlskop on 20 September, 2014 - 18:58Hi Guys
I want formulas that will calculate a summary of averages from the timesheet attached(actual spreadsheet has over 50,000 rows with 12 employee). My aim is to be able to see, when I expand each subtotal/month, the average hours worked per day/week/month for the month/subtotal and in the same manner as the number of counts for all employees - summarised below the table (highlighted yellow).
In other words, each subtotal will have its summary of averages below the table when I collapse it. Cells without data should be ignored in the formula
Many thanks

Recent comments
6 years 6 weeks ago
6 years 44 weeks ago
7 years 4 weeks ago
7 years 7 weeks ago
7 years 8 weeks ago
7 years 13 weeks ago
7 years 21 weeks ago
7 years 22 weeks ago
7 years 22 weeks ago
7 years 22 weeks ago