| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count consecutive cells then start over | Excel Worksheet Functions | |||
| Start Cells with Specific Value | Excel Discussion (Misc queries) | |||
| use Now() in two cells for start and finish times | Excel Worksheet Functions | |||
| Empty cells at start of x axis | Charts and Charting in Excel | |||
| Cells disappear when I start to enter a formula | Excel Programming | |||
Linear Mode
