Add a particular number as a running total

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

Guest

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.
 
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
 
Dear Pete, I am going to try it now. Thank you so much for your help.
Cuqui
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to add numbers in same cell? 2
I have a column of numbers, some positive and some negative. 6
A staying on schedule formula: 2
Match and delete rows on two different sheets from reference numbers 4
Total Gratuity Leave Please help 2
formula to add number comined with text 1
TOTAL OF A RANGE SHOULD BE 3
Count entries in the column translating to minutes. 5

Back
Top