ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Add a particular number as a running total (https://www.excelbanter.com/excel-worksheet-functions/87169-add-particular-number-running-total.html)

Cuqui

Add a particular number as a running total
 
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.

Pete_UK

Add a particular number as a running total
 
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


Cuqui

Add a particular number as a running total
 
Dear Pete, I am going to try it now. Thank you so much for your help.
Cuqui

"Pete_UK" wrote:

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



MartinW

Add a particular number as a running total
 
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




All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com