Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|