Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cuqui
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cuqui
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
RUNNING TOTAL LOST IN EXCEL 2000 Excel Worksheet Functions 7 December 27th 05 05:52 AM
Add total number of rows (text) in a column rostroncarlyle Excel Worksheet Functions 1 December 15th 05 06:25 AM
% of running total in pivot table eggman Excel Discussion (Misc queries) 0 October 13th 05 04:31 PM
Need to Count number of occurrences and get percentage of total JennLee Excel Worksheet Functions 3 June 21st 05 09:56 PM
Running Total doublej0 Excel Worksheet Functions 1 March 11th 05 05:28 PM


All times are GMT +1. The time now is 08:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"