Sum if plus Vlookup (maybe)

[applebyd]

Morning all,

I've a problem here I *really* should be able to solve
but... Seem to have an attack of 'wood for the trees'
and am tying myself in knots!

I have a workbook with five sheets (Wk1-Wk5) that contain
static data for agents in a contact centre.

Now some of this data is in an odd time format (eg: 144:22:44)

Names as rows Data as columns

Now:

The names may change on a week to week basis, so for a monthly sheet I
can't just sum ='Week 1:Week 5'!D6

Essentially I *think* I need a sum coupled with a Vlookup based on a 'Master'
list of Agents to make sure all are included. However, can't see what happens
if they are missing from one week as it returns an #N/a.

Brain hurting, as, I'm sure there's an easier way than dragging everything into
one sheet using VBA and summing from there.

Any help greatly appreciated, unfortunatly I can't post the sheet here due to limits
with the office network.

Basic layout

NAME 1== HOURS == Calls == Talk Time == Aux Time == Lunch == Breaks==

NAME 2== HOURS == Calls == Talk Time == Aux Time == Lunch == Breaks==

NAME 3== HOURS == Calls == Talk Time == Aux Time == Lunch == Breaks==

It's the variable names week on week that's throwing me!

I've had a troll through using serach, however, it's a bit too specific to
narrow, or, more likely, I'm being dumb!

Regards

DaveA

 

[DATTATREYA]

Be clear on your question we unable understand your requirement.

 

[applebyd]

Be clear on your question we unable understand your requirement.

Which part?

Regards

DaveA

 

[RoryA]

You would, IMO, be far better off using one sheet with an additional column for week number.
However, you may still be able to do what you want using either data consolidation, or a pivot table based off consolidation ranges.

 

[applebyd]

Ah.............

Hadn't thought of the pivot option!

I'll give that a go!

Thanks

DaveA