shipping qty volatility lookup

[tavwtby]

I have an issue that I cannot wrap my head around. I am looking for ordering volatility within a certain time frame. So to explain, the contract has an annual demand qty. (ADQ), we are to keep half of that ADQ on hand, according to contract. From time to time, the customer will order in chunks that exceed that half of demand qty. What I am trying to find, is a formula that will look through all 36000 orders since inception of contract, and isolate qty's that exceed half of the ADQ, within a 6 month period or less. I have uploaded my example to show what I am talking about that I did manually, but when I go to manage attachments, the paper clip, it does not show up
Edit: I see that it did show up. So the highlighted section in red, is customer volatility, ordering more than half ADQ within a one day period, but it could be as large as a six month period. Hope that makes sense.

[Richard Buttrey]

Does the attached give you a way forward.

I've added a helper column and two cells K3:L3 to record the sampling date range.

Was your total of 5911 a typo since it doesn't include the 339 in A25?

[tavwtby]

This is kinda what I am looking for, I think that I should have put more information in the example I uploaded, so that there are multiple part numbers and customers, along with the columns of ADQ and AADQ. What I have attached now is the shipping list, with QTY, customer, order date, p/n, then a second set of columns with the part numbers, AADQ and ADQ. the AADQ is the Adjusted Annual Demand Qty, ADQ is the Annual Demand Qty. So, what I need, is to sort out customers that ordered, within a specific time period, quantities that exceed both half of the ADQ and the AADQ. The p/n's in the columns do not match up in the same row, so a VLOOKUP, would probably be needed to first find that, then somehow figure out if each customer had ordered more than half ADQ or AADQ within a specific time period, say six months, or one month, something that I can change to get different metrics for charts. I realize there is a lot of info there to pour over, but I have over 36000 shipments and to do it one by one, would take longer than I have to get it submitted. Thanks for reply and any help, I will continue to try out things myself in the meantime.

[Richard Buttrey]

There was nothing uploaded. When you do please ensure that you have manually added the results you expect so that we may check any solution against your requirement.

[tavwtby]

I can get to the VLOOKUP to match the numbers, but figuring out the quantites for each specific customer, within a specific date range is baffling me, my excel skills are just not that good.