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

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.

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

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

http://groups-beta.google.com/group/...909c39b0cd3c1/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Marketneutral wrote:
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.