| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cumulative Values
I'm trying to find a quick way to to create a cumlative list of values. The
example below will hopefully illustrate what I'm attempting to do. Column A Column B Column C Date Premium Cumlative Premium Row 1 01/01/06 £200,000 £200,000 Row 2 31/03/06 £150,000 £350,000 Row 3 01/06/06 £340,000 £690,000 What I've done at the moment is use the following formulae in Column C: - Row 1 =Sum(B1) Row 2 =Sum(B1:B2) Row 3 =Sum(B1:B3) With the above method I have to type each formula in one at a time. I've tried dragging the formula but it doesn't do what I need it to do. Is there an easy way? Thank you. - David |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cumulative Values
David Wrote: I'm trying to find a quick way to to create a cumlative list of values. The example below will hopefully illustrate what I'm attempting to do. Column A Column B Column C Date Premium Cumlative Premium Row 1 01/01/06 £200,000 £200,000 Row 2 31/03/06 £150,000 £350,000 Row 3 01/06/06 £340,000 £690,000 What I've done at the moment is use the following formulae in Column C: - Row 1 =Sum(B1) Row 2 =Sum(B1:B2) Row 3 =Sum(B1:B3) With the above method I have to type each formula in one at a time. I've tried dragging the formula but it doesn't do what I need it to do. Is there an easy way? Thank you. - David Hi David, in Row 2 =Sum(C1+B2), then drag down oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=568529 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cumulative Values
David, in C2 type, =B2. Then, in C3 type =C2+B3. You can copy this formula
down to get your cumulative values. HTH -- Sincerely, Michael Colvin "David" wrote: I'm trying to find a quick way to to create a cumlative list of values. The example below will hopefully illustrate what I'm attempting to do. Column A Column B Column C Date Premium Cumlative Premium Row 1 01/01/06 £200,000 £200,000 Row 2 31/03/06 £150,000 £350,000 Row 3 01/06/06 £340,000 £690,000 What I've done at the moment is use the following formulae in Column C: - Row 1 =Sum(B1) Row 2 =Sum(B1:B2) Row 3 =Sum(B1:B3) With the above method I have to type each formula in one at a time. I've tried dragging the formula but it doesn't do what I need it to do. Is there an easy way? Thank you. - David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding zero values in charts | Charts and Charting in Excel | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Linear Mode
