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!
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!