Sum row values corresponding to other row values within a single array

[ttantheman]

Been cracking my head for ages on this.

I have an array (attached file) containing various data columns and then 3 different values ("Machine", "Operator", "Time") across the rows. I am trying to sum the "Time" values corresponding to each "Machine" value within the same column (but different row). I am also trying to sum within date ranges which are in the data columns.

Output is ideally in a simple matrix (Cells B9:D12). So, for cell C10, I'm trying to sum all "Time (Mins)" values for machine "M1" for the "Setup" phase.

So far I've tried SUMPRODUCT but have only been able to count the machine cells, but not sum the "Time" cells corresponding to them. My hypothesis is SUMPRODUCT in combination with some other function will do the trick.

Would really appreciate some help or a steer on this.