I'm working on a spreadsheet that the user wants one formula for figuring out
the average overtime worked per week (she wants to be able to copy and paste
it where needed).

Each person listed in the sheet has 1 row per pay period along with the
total amount of hours and total amount of hours worked overtime. Each person
has a different amount of rows, though. It's similar to

Date Person Name Total hours OT
01/01/01 Person name 50 10
01/20/01 Person Name 40 0

I have a general formula, but I can't figure out how to get it to adjust
itself according to the person. The formula also can't be that complicated.
Any ideas? Thanks!

Sort your table by person, then apply Subtotals and choose Person from the
Group by list, Average from the function to apply list in Subtotals Dialog.
Regards,
Stefi


"KC8DCN" wrote:

I'm working on a spreadsheet that the user wants one formula for figuring out
the average overtime worked per week (she wants to be able to copy and paste
it where needed).

Each person listed in the sheet has 1 row per pay period along with the
total amount of hours and total amount of hours worked overtime. Each person
has a different amount of rows, though. It's similar to

Date Person Name Total hours OT
01/01/01 Person name 50 10
01/20/01 Person Name 40 0

I have a general formula, but I can't figure out how to get it to adjust
itself according to the person. The formula also can't be that complicated.
Any ideas? Thanks!