Averaging weekly data from daily data from multiple spread sheets - functions ?

**oniete1997** · 01-07-2012, 12:16 AM

I am working on a project that my boss wants and I would like to know if there is an function or formula I can use to help.

Currently I collect daily proudction data for multiple tasks that an employee does thru out the day. All employees have their own tab on a excel workbook (see attached - weekends are in gray). I can easily get the monthly average for.

The problem is I now have to produce a weekly average as well as the monthly average that will then be linked into charts on a seperate spread sheet. Is there a way to use any funtion or forumula instead of going thru each employees tasks by week and summing it manually?

**reachhari** · 01-07-2012, 03:22 AM

Hi,

I have used the naming concept and arrived to a solution. Using the indirect function I can choose the employee for whom we need the summarization.

I have name all the three columns of each table of each employee. Have a look at the Name manager for more info on how the cells are named.

Please refer to the last sheet of the attached file how I have worked out. Let me know your thoughts.

Thanks