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.