Shift Planner VlookUp+CountIf's?

Hi There
This has been driving me mad for few days now so hopefully someone here can help me out and save me more headache please

So on the attached sample you'll see that I have 2 tabs, one with shift planned and the other one is the summary tab.
What I'd like to do is to take values from each month and put them into summary tab so that I can track hours.
The trick is that as you will see this spreadsheet is poorly designed in terms of data structure (This was created by someone else and I'm not allowed to change layout)
Each colleague is allocated to area of work so what i need is basically a summary of hours worked in each month for each one of the 16 areas..

Is this even possible?
I've tried pivots and vlookup's but could not do it...




Thank You in Advance
Regards
Dan

In C2

=SUMPRODUCT(('Daily Planner'!$D$3:$ND$110),('Daily Planner'!$B$3:$B$110=$A2)*('Daily Planner'!$D$2:$ND$2=$B2))

copy down

Originally Posted by JohnTopley

In C2

=SUMPRODUCT(('Daily Planner'!$D$3:$ND$110),('Daily Planner'!$B$3:$B$110=$A2)*('Daily Planner'!$D$2:$ND$2=$B2))

copy down

OMG John! Thank for my heart!
WOOOOOOOWWWWWW

Dan

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.