Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RUNNING TOTAL | Excel Worksheet Functions | |||
Add total number of rows (text) in a column | Excel Worksheet Functions | |||
% of running total in pivot table | Excel Discussion (Misc queries) | |||
Need to Count number of occurrences and get percentage of total | Excel Worksheet Functions | |||
Running Total | Excel Worksheet Functions |