Thread: Sum cells until a value X is reaced and then start again
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marketneutral Marketneutral is offline
external usenet poster
  
Posts: 1
Default 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.

Reply With QuoteReply With Quote