VLookup to add up hours within departments and for certain project numbers

Hi,

I posted this query a few weeks ago, but it wasn't fully resolved. I have a data source spreadsheet, called 'WorkSchedule' and within that, a spreadsheet where data is entered called 'Data' (image below and attached within post):

r.JPG

end.JPG


I am trying to figure a V Look up to count up the number of hours in columns M, Q, U, Y and AB as long as certain criteria is met:

(1) Within each separate Department (eg Electrical department total hours counted separate from painting total hours)

(2) With a specific project number within the destination workbook, found in column B (eg Electrical department total hours for the project with project number '2016110050' , painting department hours for project number '2016110050')

The destination workbook I am looking to apply the VLookUp from is here (in the yellow boxes):

Vlookup.JPG


The project number I would like the VLookup criteria to apply to is in the B Column in the destination workbook in the destination workbook '' ____ ''

I have been offered several different versions of formula, but am having difficulties getting it to work:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

My sample workbook, destination file is attached. The source file is too big a file type however... but both files are both attached here and within my Onedrive:

https://1drv.ms/u/s!Ag-WnkpUjiS9hzQhvm9B9lUrP0XD

Thanks