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!
Bookmarks