Hi, any help appreciated here.
I would like a formula that can count how many cells it takes before a set value is met but not exceeded.
This will be used for inventory purposes to show how many weeks of stock we have on hand.
The attachment shows 8 weeks of forecasted sales ( B3:I3) and the number of units we have on hand (C8).
I would like, in D8, a formula that shows the number of weeks of inventory we have.
In our real spreadsheet we have weeks and weeks of forecasted sales.
So for bonus points, could the formula that counts the number of weeks change its starting count point based off an additional second cell?
IE if we are in week 2 of December I would like the formula to only count from week 2.
I hope I have explained this properly.
Thanks again
Bookmarks