Results 1 to 3 of 3

Thread: Time sum issue with formula

  1. #1
    Seeker LuisPacheco's Avatar
    Join Date
    May 2013
    Posts
    12
    Articles
    0
    Excel Version
    2016

    Time sum issue with formula



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

    Hi Folks,

    I need your input... I want to SUM the quantity (Column B) by the specific hour (D3 & D4) but I couldn't get with the SUMIFS & SUMPRODUCT formula, could some of you could shed a light on this? I'' appreciate your prompt response, Thanks in advance...

    Time QTY
    12:24:13 100 12:00:00 AM
    12:24:13 200 1:00:00 PM
    15:16:26 300
    15:16:26 400 #VALUE!
    10:19:33 500
    10:19:33 600
    11:35:20 700
    11:35:20 800
    12:24:54 900
    12:24:54 1000
    10:04:07 1100
    10:04:07 1200
    12:59:58 1300
    12:59:58 1400
    16:32:43 1500
    16:32:43 1600
    16:38:08 1700

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Did you try something like:

    =SUMIFS($B$1:$B$17,$A$1:$A$17,">="&D3,$A$1:$A$17,"<="&D4)


  3. #3
    Seeker LuisPacheco's Avatar
    Join Date
    May 2013
    Posts
    12
    Articles
    0
    Excel Version
    2016
    I'ts works pretty good, thank you so much that was to easy... Have a great date!!!

Posting Permissions

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