jammykumar
New Member
- Joined
- Sep 12, 2011
- Messages
- 1
I have some 1000 random values in column A for example: 45, 14, 9, 72 and son on. I want to add up subsequent cells in the range so that the sum is less than 100 and put the sum of the range in column B against all the cells in the range and then move up to the next range.
A B
45 68
14 68
9 68
72 99
27 99
34 97
23 97
23 97
5 97
5 97
7 97
10 10
98 98
A B
45 68
14 68
9 68
72 99
27 99
34 97
23 97
23 97
5 97
5 97
7 97
10 10
98 98
Last edited: