naridox
New member
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
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