excel running totals

K

Kathy

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?
 
J

Jacob Skaria

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
 
K

Kathy

Eduardo said:
Hi,
=sum(A1:M1)

Change range to fit your needs

if this helps please click yes, thanks

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.
 
E

Eduardo

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top