Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Totals
My Question is how to run a total on the next column from values from
preceeding Column EX: Column A Column B 1 1 2 3 3 6 4 10 5 15 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Totals
With
A list of values in Col_A, beginning in A1 This formula calculates the running total B1: =SUM($A$1:A1) Copy that formula down as far as needed Note: the Dollar Signs ($) in the formula locks the parts of the reference that they preceed. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "MAC Man" wrote: My Question is how to run a total on the next column from values from preceeding Column EX: Column A Column B 1 1 2 3 3 6 4 10 5 15 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Totals
This is exactly what I was looking for Ron. Thanks. The only thing I'd like
to improve is to not have all the following cells down the column = the last total. Is there a way to have it equal 0 until you enter a new value in the next cell in Columb A? "Ron Coderre" wrote: With A list of values in Col_A, beginning in A1 This formula calculates the running total B1: =SUM($A$1:A1) Copy that formula down as far as needed Note: the Dollar Signs ($) in the formula locks the parts of the reference that they preceed. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "MAC Man" wrote: My Question is how to run a total on the next column from values from preceeding Column EX: Column A Column B 1 1 2 3 3 6 4 10 5 15 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Totals
How about one of these?:
This one calcs the total if anything is in the Col_A cell, including text. B1: =IF(A1<"",SUM($A$1:A1),"") OR This one only calcs the total if the Col_A cell contains a number B1: =IF(ISNUMBER(A1),SUM($A$1:A1),"") Does that help? *********** Regards, Ron XL2002, WinXP "MAC Man" wrote: This is exactly what I was looking for Ron. Thanks. The only thing I'd like to improve is to not have all the following cells down the column = the last total. Is there a way to have it equal 0 until you enter a new value in the next cell in Columb A? "Ron Coderre" wrote: With A list of values in Col_A, beginning in A1 This formula calculates the running total B1: =SUM($A$1:A1) Copy that formula down as far as needed Note: the Dollar Signs ($) in the formula locks the parts of the reference that they preceed. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "MAC Man" wrote: My Question is how to run a total on the next column from values from preceeding Column EX: Column A Column B 1 1 2 3 3 6 4 10 5 15 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Totals
Thank you Ron, Both formulas work!
"Ron Coderre" wrote: How about one of these?: This one calcs the total if anything is in the Col_A cell, including text. B1: =IF(A1<"",SUM($A$1:A1),"") OR This one only calcs the total if the Col_A cell contains a number B1: =IF(ISNUMBER(A1),SUM($A$1:A1),"") Does that help? *********** Regards, Ron XL2002, WinXP "MAC Man" wrote: This is exactly what I was looking for Ron. Thanks. The only thing I'd like to improve is to not have all the following cells down the column = the last total. Is there a way to have it equal 0 until you enter a new value in the next cell in Columb A? "Ron Coderre" wrote: With A list of values in Col_A, beginning in A1 This formula calculates the running total B1: =SUM($A$1:A1) Copy that formula down as far as needed Note: the Dollar Signs ($) in the formula locks the parts of the reference that they preceed. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "MAC Man" wrote: My Question is how to run a total on the next column from values from preceeding Column EX: Column A Column B 1 1 2 3 3 6 4 10 5 15 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Totals
The other way is that you do as below:
A B 1 5 =if(isnumber(a1),a1,"") 2 9 =if(isnumber(a2),b1+a2,"") and then you can copy the second formula to where ever you want i think it takes computer's memory less thanks -- Farhad Hodjat "MAC Man" wrote: This is exactly what I was looking for Ron. Thanks. The only thing I'd like to improve is to not have all the following cells down the column = the last total. Is there a way to have it equal 0 until you enter a new value in the next cell in Columb A? "Ron Coderre" wrote: With A list of values in Col_A, beginning in A1 This formula calculates the running total B1: =SUM($A$1:A1) Copy that formula down as far as needed Note: the Dollar Signs ($) in the formula locks the parts of the reference that they preceed. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "MAC Man" wrote: My Question is how to run a total on the next column from values from preceeding Column EX: Column A Column B 1 1 2 3 3 6 4 10 5 15 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary of Multiple Worksheet Running Sum Totals | Excel Worksheet Functions | |||
How do I do running Totals in a Pivot Table | Excel Worksheet Functions | |||
How do I add totals up from different sheets? A running total. | Excel Worksheet Functions | |||
How to hide unused cells when running accumulated totals | Excel Worksheet Functions | |||
Running Totals | New Users to Excel |