I am trying to calculate number of sales orders and total qty dropped in the system to be processed at below given time slots.Pls find data attached.I would like to identify which time slot has most orders dropped in and which time slot has most qty needs to be processed.
6am-9am
9am-12pm
12pm-3pm
3pm-6pm
6pm-9pm
9pm-5:59am
Any help wtih this would be greatly appreciated.
Hi and welcome to the forum
If you put this in D2 and copy down...
=IF(COUNTIF($B$2:B2,B2)>1,"",SUMIF($B$2:$B$1054,B2,$C$2:$C$1054))
Then on the column D drop-down, scroll down in that, and uncheck BLANKS, you will be left with a list "order create date and time" and its totals
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
find the attached file
Re: how to calculate number of sales orders and qty created at given time slots?
It works perfect!!!
Thanks all for your quick response.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks