I have a table of employees and hours worked i'm trying to summarize in a dashboard on a separate sheet. I'm trying to write a formula that makes adding new employees to the table and dashboard easy.
Here is a screenshot of the data table:
data_table.png
Here is a sample of what the dashboard would look like.
dashboard.png
I would like to formula to use the name in column A as a match for the datatable,and aggregate the weeks into months. As new people will be being added and removed, i'm trying to make it simple add new people the list. I have about 40 people I'm tracking hourly data for at present, with them changing every month.
Bookmarks