I have a bunch of estimated monthly sales and an existing inventory, I'm trying to calculate how many months of inventory I have. Here is a simple example:
So the answer would be 2.
I've tried a bunch of ways, any help would be great!
This was as close as I could get, but I'm getting an incorrect answer
=MATCH(B2,INDEX(SUBTOTAL(9,OFFSET(A2,,,,COLUMN($A$2:$BF$2))),0))
This was the sample set I used and it doesn't work.
Units on hand: 3230
Sales #
Inventory | Jan Sales | Feb Sales | Mar Sales | Apr Sales | |
100 | 90 | 10 | 30 | 10 |
So the answer would be 2.
I've tried a bunch of ways, any help would be great!
This was as close as I could get, but I'm getting an incorrect answer
=MATCH(B2,INDEX(SUBTOTAL(9,OFFSET(A2,,,,COLUMN($A$2:$BF$2))),0))
This was the sample set I used and it doesn't work.
Units on hand: 3230
Sales #
125 | 125 | 125 | 125 | 125 | 241 | 241 | 241 | 241 | 147 | 147 | 147 | 147 | 147 | 180 | 180 | 180 | 180 | 130 | 130 | 130 |