Sumproduct with Elapsed Time Compared to Other Col

[Naridox]

Attempting to sumproduct compare two columns to create elapsed time per category.

Worksheet: Johnson
Current Attempts
=SUMPRODUCT(($H$16:$H$2000=J2)*($G$16:$G$2000)) = #VALUE!
=COUNTIFS($H$16:$H$2000,J4,$G$16:$G$2000,"*") = 0
=SUMPRODUCT(($H$16:$H$2000=J3)*($G$16:$G$2000>0)) = 24:00

I want to put sumproduct sums in I2-I13 for each category.


Then I want to be able to sumproduct the same elapsed time from the "Johnson" worksheet to the "DASH" Worksheet so I can get time breakdowns per person who will be listed based on faults.

Please help!

 

[r2c2]

@Naridox

I am not sure why you are using SUMPRODUCT.

You could use SUMIFS to get the result.

like this:

=SUMIFS($G$16:$G$2005,$H$16:$H$2005,J2)

Let me know if I am missing something.

 

[Naridox]

Thank you! Worked like a charm!