View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
uw805
 
Posts: n/a
Default 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.