Formula for running total until a mark is reached and then restart

[celias]

Hello, I am looking for an excel formula that does the following:


We have a mark to reach, let's say MARK=12


In column A we have "random" amounts.
In column B, I want a formula that:
- Calculates the running amount in col A and
- If the running total has not reached then MARK then leave the cell empty, otherwise, display that running total, and THEN
- next cell repeats the process but ignoring the cells that were part of a running total previously displayed.


Example:
MARK = 12
Col A Col B
7
4
5 16
1
6
5 12
6
8 14
4
3
4
8 19
... and so on
Can you do this? I have been working on this for quite a few hours but haven't been able to find a formula for this. And it needs to be a formula; no VBA or POwer Query should be involved in a solution for this. Any tip would be very much appreciated.
Thank you in advance for your time, knowledge and kindness,
Celia

 

[sheetspread]

Excel 2010
	A	B
2	7
3	4
4	5	16
5	1
6	6
7	5	12
8	6
9	8	14
10	4
11	3
12	4
13	8	19
Sheet9

Cell Formulas
Range	Formula
B2	=IF(SUM($A$2:A2)-SUM($B$1:B1)>=12,SUM($A$2:A2)-SUM($B$1:B1),"")

 

[Fluff]

Cross posted https://www.ozgrid.com/forum/forum/...-total-until-reaching-a-mark-and-then-restart

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.