Sum multiple columns with multiple criteria in Row and Columns

[jhl0227]

Hi everyone,

I'm trying to sum the total hours of resources using mutiple matches in columns and rows.

Sheet one has the raw data where resource hours are recorded based on multiple criteria including, Shift (Column B), Date (Column D), Stage (Column E) and etc.


Sheet 1

I am trying to sum the total hours of resource matching the Shift, Date and Stage and return the sum of the hours in Cell J5.
I was trying to use the sumproduct but that would not work with multiple arrays.

Sheet 2

Could someone please give me advice on the best way to tackle this?

Thank you!

 

[kweaver]

Welcome to Mr. Excel.
If you use XL2BB you'll be more likely to get quick replies because it won't require trying to replicate your data.