Cumulative Totals Sheet Referencing Eight Other Sheets

michaelsdk

New member
Joined
Jul 22, 2013
Messages
1
Reaction score
0
Points
0
I'm trying to chart out productivity on an individual basis for a department at my company. I have 8 sheets currently set up for the sub-departments and their returning employees. In each of these sheets, I also have room to expand and add new employees down the road. My main issue now is that my supervisor wants a sheet where he can enter a week start date (available on all other sheets) and an employee's initials (some available on singular sheets; some on multiple sheets) and have excel return values for number of jobs, number of images, or other numerical aspects of work. I'm having a problem in thatI'm not sure how to tell excel to search for a specific set of initials (C1:V1) corresponding to a date (A:A) which are both manually entered into a separate sheet and returning appropriate values. For example:

This would be my data sheet:
RABKO
8/5/13Images2000017500
8/5/13Hours4040
8/5/13Images/Hour500437.5
8/12/13Images2500021000
8/12/13Hours4540
8/12/13Images/Hour555.6525

And this would be my results sheet:
WhoRA
Date8/12/13
Images/Hour555.6

I believe VLOOKUP could work, the problem is that I'm not sure how to return the Images/Hour instead of Images (since Images is the first numerical result for 8/12). I also don't know how to have it account for situations such as RA working in multiple departments and having results on another sheet and factoring the two together.

Any help on this problem would be greatly appreciated. I can also provide additional information to an extent in order to better clarify my problem.
 

Herbds7

Banned
Joined
May 8, 2013
Messages
197
Reaction score
0
Points
0
Your "data sheet" seems to be a weekly summary (with calculations) of some daily base data.
It would be easier to work with the base data. Upload.
Expect the "results" to be in the form of a PivotTable.
 
Top