Hi There
I am looking for a formula that will use the following factors to total until criteria is met
I have time intervals in A2:A61
Corresponding results in column B2:B61
My criteria total is in O3 (I also have a second criteria in F2)
In column O6 downwards I want each result from A1:A60 to fill in until the total in O66 gets within the creteria in O3,I would also only like the results to show after time interval criteria in F2 (so for example if F2 has 20 seconds i want it to look at the table in A2:A61 and return any result form B2:B61 that are 20 and above to total until criteria in O3 is met/nearly met), it will more than likely never get the right number but if possible I don’t want it to exceed the criteria.
I have tried vlookups, subtotals, ifs formula as well as looking online for a similar question but to no avail.
I have included an example of my sheet if it helps.
Any help would be appreciated.Attachment 411627
Bookmarks