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