Cumulative calculation

[beeky]

In cell (say A40) I have a calculated figure of Fee plus VAT. This has to be taken away from an income figure but accululates each month. So for example the figure in January is say £126. What I want is in February this to be the January figure plus the same again in February and then in March the combine February figure plus the samer again for March.

So in effect it would be for February = A40+B40 and in March =B40+C40, April would be =C40+D40 and so on. Is there a better way of doing this please. I have attached an example of what I want to achieve but would like it so I can drag a formula across a range of columns.

[ChemistB]

In B19, you can use

=$A19+A19
that can be dragged across or down.
The $ anchors the A (column A) so that doesn't change when you copy the formula to different cells.
Is that what you were looking for?

[beeky]

Many thanks - thats exactly what I wanted.