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?

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?

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?

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.

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.