Adding series in a table and breaking again when the value reaches a limit

**adriandwor** · 10-25-2021, 04:35 PM

Hey everyone,

I'm working on a school project and maybe one of you can help me with the following excel problem. I tried to google a little bit but I can't properly formulate my question.

I have a table in excel that looks like this:

6fqoi6r.png

I'd like to be able to sum contents in U column automatically until the result reaches 235 and then start again from 0. Column B represents different days of the week. When a day changes, the calculations also should start from 0. There are about 5000 data points Can anyone help?

Thanks a lot

**Estevaoba** · 10-25-2021, 07:25 PM

Welcome to the forum.

I created a helper column with this formula in X2, for example, and copied down:
=QUOTIENT(SUM(U$2:U2),235)

Then this formula in V2 copied down will do the trick:
=SUMIF(X$2:X2,QUOTIENT(SUM(U$2:U2),235),U$2:U2)

You may have to change commas to semi-colons.

Good luck!