Sumproduct with Elapsed Time Compared to Other Column

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!View attachment 1704 Tracker DPTTS.xlsx

try:
=SUMPRODUCT(--($H$16:$H$2000=J2),($G$16:$G$2000))

It worked! Can you tell me what "--" accomplishes? I've seen it elsewhere but I don't understand what it means.

it converts TRUEs and FALSEs to 1s and 0s respectively, so you can do arithmetic on them.
See:
http://stackoverflow.com/questions/3286197/what-does-in-excel
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
http://stackoverflow.com/questions/33500747/meaning-of-two-minus-signs-together-double-unary
https://answers.microsoft.com/en-us...mproduct/9fee1133-130f-4261-90b8-d32d5b885f9a

cross posted without links:
http://forum.chandoo.org/threads/sumproduct-with-elapsed-time-compared-to-other-col.33931/
naridox, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

Oh dear. Thanks for the update. I'm new to forum posting. I will remember in the future! Thank you!