#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default excel running totals

I am trying to set a running total across the page, ie. by row, not column. I
have a series of numbers entered each week and a column at the end of the row
for the total. How do I make that total change each time I enter a new number?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default excel running totals

Suppose the last column is J and column K is the total column apply the formula

=sum(A1:J1)

If this post helps click Yes
---------------
Jacob Skaria


"Kathy" wrote:

I am trying to set a running total across the page, ie. by row, not column. I
have a series of numbers entered each week and a column at the end of the row
for the total. How do I make that total change each time I enter a new number?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default excel running totals

Hi,
=sum(A1:M1)

Change range to fit your needs

if this helps please click yes, thanks

"Kathy" wrote:

I am trying to set a running total across the page, ie. by row, not column. I
have a series of numbers entered each week and a column at the end of the row
for the total. How do I make that total change each time I enter a new number?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 144
Default excel running totals



"Eduardo" wrote:

Hi,
=sum(A1:M1)

Change range to fit your needs

if this helps please click yes, thanks

"Kathy" wrote:

I am trying to set a running total across the page, ie. by row, not column. I
have a series of numbers entered each week and a column at the end of the row
for the total. How do I make that total change each time I enter a new number?


Thank you for your reply, however, it doesn't do what I want. I want to
enter numbers across columns in a single row, ie. row 1 columns C to O and
have the total update automatically in the total column (column P) when I put
a number in a cell in the same row.
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default excel running totals

Hi Kathy,
Put this formula in column P when you enter a number in one of the columns
the total will update automatically

=sum(C1:O1)

"Kathy" wrote:



"Eduardo" wrote:

Hi,
=sum(A1:M1)

Change range to fit your needs

if this helps please click yes, thanks

"Kathy" wrote:

I am trying to set a running total across the page, ie. by row, not column. I
have a series of numbers entered each week and a column at the end of the row
for the total. How do I make that total change each time I enter a new number?


Thank you for your reply, however, it doesn't do what I want. I want to
enter numbers across columns in a single row, ie. row 1 columns C to O and
have the total update automatically in the total column (column P) when I put
a number in a cell in the same row.

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 totals Reggie D.[_2_] New Users to Excel 1 May 21st 09 07:29 AM
Running Totals SJT Excel Discussion (Misc queries) 3 March 3rd 07 04:49 PM
Running totals Carol A. Excel Discussion (Misc queries) 5 January 10th 07 10:48 AM
running totals [email protected] Excel Discussion (Misc queries) 4 April 22nd 06 04:25 PM
Running totals in excel chuck2 New Users to Excel 1 December 14th 05 08:27 PM


All times are GMT +1. The time now is 07:51 AM.

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"