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