Did you try something like:
=SUMIFS($B$1:$B$17,$A$1:$A$17,">="&D3,$A$1:$A$17,"<="&D4)
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
Did you try something like:
=SUMIFS($B$1:$B$17,$A$1:$A$17,">="&D3,$A$1:$A$17,"<="&D4)
I'ts works pretty good, thank you so much that was to easy... Have a great date!!!
Bookmarks