Calculating Inventory Sell Through by month based on multiple criteria

It was recommended that this may be best suited for VBA rather than an Excel Formula. Here is the link to the original thread in "Formulas & Functions" http://www.excelforum.com/excel-form...ml#post3867192

I am trying to calculate inventory sell through by month, but am running into a lot of issue. Below is a sample data set. The month will only reach 100% sell through when the quantity sold equals the amount received in a month. In the below sample, you see that 2014-04 achieved 100% sell through because 1 was sold in April, 2 in May, and 7 in June (equaling 10). 2014-05 achieves 87% sell through because there were 5 sold in July, 4 in August, 3 in Sept, and 1 in October (equaling 13). The other issue is that there would be 200,000 rows in the Excel sheet that contain multiple different SKU's, so the formula would have to look at each SKU and calculate only on the group of those similar SKU's. Please advise if I can provide any additional details.

Example.xlsx

Bump......