Results 1 to 6 of 6

Thread: Sumproduct with Elapsed Time Compared to Other Column

  1. #1
    Acolyte naridox's Avatar
    Join Date
    Feb 2017
    Location
    NCR
    Posts
    30
    Articles
    0
    Excel Version
    2013

    Sumproduct with Elapsed Time Compared to Other Column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!1704 Tracker DPTTS.xlsx
    Christian
    Information Designer
    National Capital Region

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,568
    Articles
    0
    Excel Version
    365
    try:
    =SUMPRODUCT(--($H$16:$H$2000=J2),($G$16:$G$2000))

  3. #3
    Acolyte naridox's Avatar
    Join Date
    Feb 2017
    Location
    NCR
    Posts
    30
    Articles
    0
    Excel Version
    2013
    It worked! Can you tell me what "--" accomplishes? I've seen it elsewhere but I don't understand what it means.
    Christian
    Information Designer
    National Capital Region

  4. #4

  5. #5
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,568
    Articles
    0
    Excel Version
    365
    cross posted without links:
    http://forum.chandoo.org/threads/sum...her-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

  6. #6
    Acolyte naridox's Avatar
    Join Date
    Feb 2017
    Location
    NCR
    Posts
    30
    Articles
    0
    Excel Version
    2013
    Oh dear. Thanks for the update. I'm new to forum posting. I will remember in the future! Thank you!
    Christian
    Information Designer
    National Capital Region

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •