brainboxbiscuit
New Member
- Joined
- Oct 4, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi I'm trying to count the max number of forecast cells which sum up to less than the order amount of 300
eg, 90+90+60+50=290, which is the highest summed value but is less than my order total of 300 so this is 4 weeks. This is the answer I want in my wks cover cell. I want my wks cover cell to show 4.
90+90+60+50+30=320 is greater than 300 and therefore do not want my wks cover to show this as its higher than 300
Can anyone help with the formula pls? (I have approx 400 lines with multiple different inputs so need something which helps multiple times, not just for this one instance)
Thanks
eg, 90+90+60+50=290, which is the highest summed value but is less than my order total of 300 so this is 4 weeks. This is the answer I want in my wks cover cell. I want my wks cover cell to show 4.
90+90+60+50+30=320 is greater than 300 and therefore do not want my wks cover to show this as its higher than 300
Can anyone help with the formula pls? (I have approx 400 lines with multiple different inputs so need something which helps multiple times, not just for this one instance)
Thanks