Time sum issue with formula

[LuisPacheco]

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

[NBVC]

Did you try something like:

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

[LuisPacheco]

I'ts works pretty good, thank you so much that was to easy... Have a great date!!!