Cumulative Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
David said:
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
Click to expand...
Hi David,
in Row 2 =Sum(C1+B2), then drag down

oldchippy :
 
David, in C2 type, =B2. Then, in C3 type =C2+B3. You can copy this formula
down to get your cumulative values. HTH
 
Back
Top