Add a particular number as a running total

C

Cuqui

How can I add the number 7, for example so that in each cell the number gets
added. For example. 7 +7=14+7=21, and so forth.

Thank you.
 
P

Pete_UK

Put 7 in cell A1. Enter this formula in cell A2:

=A1+7

Copy A2 down the column for as many times as you want to do this.

Hope this helps.

Pete
 
M

MartinW

Hi Cuqui,

You can also put 0 in A1 and 7 in A2 then highlight both
cells, hover your cursor over the bottom right corner of
A2 and it will change into a small cross, click and drag the cross as far
down the column as you need.

HTH
Martin
 
Top