Hello-

I'm having much difficulty performing some functions for a sheet.

Basically, I have a sheet counting time for three different sites by week.

So, I have all times in one list. Column H indicates site 1, site 2, site 3 (actually indicated with text).

Column P indicates the week (week 1, 2 3, etc...)

The sheet needs to find an average all values in column K by week number from SITE 1 only.

I've been trying to combine functions, but my formulas tend to stop working properly. I also have dates listend on wach row, but not sutre if Excel will be able to subtotal between sunday-saturday or something like that. Can anyone help?

thanks!