Andre Pires
New Member
- Joined
- Dec 9, 2019
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Dear all,
I would like an excel formula to provide me how many rows until a certain sum is reached:
For instance:
here you'll see that I have 383 in stock and I would like to know how many week until I deplete the stock.
According to the calculus it should cover until W51 (where the final outcome by excel should be 6). Notice also that the opening stock might not sum exactly the value (this would be it would be between 4 or 5 weeks)
In general it would a function Sum until x value - but such function doesn't exist.
Can you help me with this?
Regards
I would like an excel formula to provide me how many rows until a certain sum is reached:
For instance:
here you'll see that I have 383 in stock and I would like to know how many week until I deplete the stock.
According to the calculus it should cover until W51 (where the final outcome by excel should be 6). Notice also that the opening stock might not sum exactly the value (this would be it would be between 4 or 5 weeks)
In general it would a function Sum until x value - but such function doesn't exist.
Can you help me with this?
Regards