ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum (https://www.excelbanter.com/excel-discussion-misc-queries/188284-sum.html)

From the given range whereever the sum exceeds a value say 50K It should stop
and start from the next value. How to get this?????
--
Ravi Abburi

Hi Ravi,
Assuming you have your list of numbers in column A, apply this formula to
cell B2.
=IF((B1+A2)=50000,A2,B1+A2).
Then copy it and paste to other cells in column B. This way you will get
what you want in column B. Also don't forget to copy cell A1 to B1.

--Parag

"Ravia2buri" wrote:

From the given range whereever the sum exceeds a value say 50K It should stop
and start from the next value. How to get this?????
--
Ravi Abburi

Dear Parag,

thank you so much. Can you help me how I can Split the data into different
sheets where the total meets 50K
--
Ravi Abburi

"Parag" wrote:

Hi Ravi,
Assuming you have your list of numbers in column A, apply this formula to
cell B2.
=IF((B1+A2)=50000,A2,B1+A2).
Then copy it and paste to other cells in column B. This way you will get
what you want in column B. Also don't forget to copy cell A1 to B1.

--Parag

"Ravia2buri" wrote:

From the given range whereever the sum exceeds a value say 50K It should stop
and start from the next value. How to get this?????
--
Ravi Abburi

Hi Ravi,
Apply this formula in column C starting from cell C2.
=IF((B1+A2)=50000,"Break"," ").
You will get "Break" where sum exceeds the said limit. then by using
Copy-Paste, you can move data to other spreadsheets as you want. But this
will be suitable only if your breakpoints are small in number, else it will
be tedious task.

--Parag

"Ravia2buri" wrote:

Dear Parag,

thank you so much. Can you help me how I can Split the data into different
sheets where the total meets 50K
--
Ravi Abburi

"Parag" wrote:

Hi Ravi,
Assuming you have your list of numbers in column A, apply this formula to
cell B2.
=IF((B1+A2)=50000,A2,B1+A2).
Then copy it and paste to other cells in column B. This way you will get
what you want in column B. Also don't forget to copy cell A1 to B1.

--Parag

"Ravia2buri" wrote:

From the given range whereever the sum exceeds a value say 50K It should stop
and start from the next value. How to get this?????
--
Ravi Abburi