Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DaWoff

  1. DaWoff

    Sum to a certain value, then reset the sum function

    @Skip, I appreciate the assistance. This did exactly what I was needing. I have been working on so many different variations of formulas that I was confusing myself. I appreciate your assistance with this!
  2. DaWoff

    Sum to a certain value, then reset the sum function

    @Skip, again thanks for all of the help. This latest formula will help ID the first group when it reaches the limit. After reaching the limit the first time, it just pulls the value from column A. I am trying to find a way to 'reset' the counter so it start over and ID the next group.
  3. DaWoff

    Sum to a certain value, then reset the sum function

    @Skip, Thank you for the assistance. I am not sure that I understand how to write the formula for your last post. I have the data values in column A, your initial formula previously posted in column B, a rolling sum in column C (=sum($A$1:A1), and the validation formula in column D...
  4. DaWoff

    Sum to a certain value, then reset the sum function

    Thank you for the response. This formula is grouping the numbers for the absolute value of the sum (i.e. a group when the total sum exceeds the next 25M). This is almost what I need. Where this particular formula is not meeting my needs is in group 1. The sum of groups 0 and 1 do not exceed...
  5. DaWoff

    Sum to a certain value, then reset the sum function

    I have a column of data (column A). I need to find a way to sum the column up to a certain value, let's say 25,000,000. When the threshold is met, the sum function needs to 'reset' so that threshold is never exceeded. My ultimate end state is to be able to group rows of data based on a summed...
See more

Part and Inventory Search

Back
Top