Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running total array?
Can anyone help me with a formula that can return an array with a "running
total" from a row of values? For example: A B C D E F Row 1: 1 0 2 3 0 5 I'm looking for a function/formula that would return an array that has the total of all values as you move from A1 to F1: {1,1,3,6,6,11} A long version of this formula would be something like: ={Sum(A1:A1),Sum(A1:B1),Sum(A1:C1),...,Sum(A1:F1)} but I will be working with much longer strings of values. Perhaps something using MMULT or SUMPRODUCT might work? Any Ideas? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running total array?
One way
=SUM(MMULT(N(TRANSPOSE(COLUMN(A1:F1))=COLUMN(A1:F 1)),TRANSPOSE(A1:F1))) entered with ctrl + shift & enter will return 28 which is the sum of {1,1,3,6,6,11} -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "uw805" wrote in message ... Can anyone help me with a formula that can return an array with a "running total" from a row of values? For example: A B C D E F Row 1: 1 0 2 3 0 5 I'm looking for a function/formula that would return an array that has the total of all values as you move from A1 to F1: {1,1,3,6,6,11} A long version of this formula would be something like: ={Sum(A1:A1),Sum(A1:B1),Sum(A1:C1),...,Sum(A1:F1)} but I will be working with much longer strings of values. Perhaps something using MMULT or SUMPRODUCT might work? Any Ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for running total | Excel Worksheet Functions | |||
How do I add totals up from different sheets? A running total. | Excel Worksheet Functions | |||
Keep a running total while using a clearable form | Excel Discussion (Misc queries) | |||
updated running total from previous pages | Excel Worksheet Functions | |||
Pivot Table - Running Total Annualised | Excel Discussion (Misc queries) |