# Thread: Sumproduct with Elapsed Time Compared to Other Column

1. ## 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.

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

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

This is a requirement, not just a request.
Why? Have a read of http://www.excelguru.ca/content.php?184

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