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...
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 |