Sum cells until a value X is reaced and then start again

[Marketneutral]

I need to sum the cells in a colum untill the progressive total reaches
a variable value such as 100000, at this point the formula needs to
start the process again in the cells below, the output in the colum can
be just a 1 oor any other symbol. can someone suggest a solution.
thanks.

 

[Dick Kusleika]

Back in my auditing days, we called it dollar size sampling. See here for
an example

http://groups-beta.google.com/group...l.misc/browse_thread/thread/817909c39b0cd3c1/