Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running totals | New Users to Excel | |||
Running Totals | Excel Discussion (Misc queries) | |||
Running totals | Excel Discussion (Misc queries) | |||
running totals | Excel Discussion (Misc queries) | |||
Running totals in excel | New Users to Excel |