Time sum issue with formula

LuisPacheco

New member
Joined
May 30, 2013
Messages
12
Reaction score
0
Points
0
Excel Version(s)
2016
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:1310012:00:00 AM
12:24:132001:00:00 PM
15:16:26300
15:16:26400#VALUE!
10:19:33500
10:19:33600
11:35:20700
11:35:20800
12:24:54900
12:24:541000
10:04:071100
10:04:071200
12:59:581300
12:59:581400
16:32:431500
16:32:431600
16:38:081700
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Did you try something like:

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

LuisPacheco

New member
Joined
May 30, 2013
Messages
12
Reaction score
0
Points
0
Excel Version(s)
2016
I'ts works pretty good, thank you so much that was to easy... Have a great date!!!
 
Top