Increment based on total

Occasional Visitor

I am keeping inventory of all my comics and I'm keeping them stored between 8 boxes in alphabetical order. I want to maintain roughly 125 in each box with a max of 150. I want to place increments by the sum total of comics I have under column titled copies once the sum reaches x I want the increment for the next set to start a new number until the total is reached again and so on. I started off with this =INT((ROW(C2)-1)/125)+1 but the 125 only represents the row number and not the totals. Is there anything I can put in place of that or a different formula to get my desired result or as close to it as possible?

0 Replies