adriandwor
New Member
- Joined
- Sep 7, 2021
- Messages
- 19
- Office Version
- 2016
- Platform
- Windows
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:
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
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:
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