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.
HTML Code:
Bookmarks