Sum

R

Ravia2buri

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?????
 
P

Parag

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
 
R

Ravia2buri

Dear Parag,

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

Parag

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
 
Top