Counting Values Until Number Reached, Then Returning Cells Counted

Hello,

I have been unable to locate, or maybe understand, how to construct a function such as this. I have a total list of quantities for items in column "A," and columns from "C" to "S" that count out projected items per day on a day-by-day basis. I would like Excel to start counting from left to right and see how many days it will take to reach the "Ordered Quantity" "A" by adding up the values inside those items-per-day columns. Returning the number of cells it needed to count to get that total value would be fine. Please see the attached document/screenshot for clarification; note that I have already filled in the "Days Worth" column partially manually to demonstrate what I am looking for, and also note that some of the values are rounded, which is why they might seem off (for example row 1 seems like it should be 9 days because of partial quantities). Thank you in advance!

-ExtraLarge

Capture.JPG

Hi
you have started this thread in the Outlook forum. Is there a reason why?

I'll move it for you, np.
Perhaps also post a sample sheet instead of a picture so we can work on it ( click Go advanced - Manage attachments)

This proposal employs 17 helper columns (U:AK) which may be moved and/or hidden for aesthetic purposes.
The helper columns are populated using: =ROUND(SUM($C2:C2),0)
Column B is populated using: =IF(AK2<A2,"N/A",AGGREGATE(14,6,U$1:AK$1/(U2:AK2<A2),1)+1)
This method matched the manually placed answers except for rows 8:9 (19 is beyond the range of days) and 17 (I believe the formulas are correct).
Let us know if you have any questions.