Forum Discussion

ds100's avatar
ds100
Copper Contributor
Feb 24, 2022
Solved

Cumulative Sum by column for two dimensional dynamic arrays?

Referencing a two dimensional dynamic array, how would I output a running total two dimensional array which calculates cumulative sums by column? Thanks in advance.  Daniel
excel
  • Lorenzo's avatar
    Lorenzo
    Feb 25, 2022

    ds100 

     

    in E3

    =MAKEARRAY(
    ROWS(TodayArray), COLUMNS(TodayArray),
    LAMBDA(r,c,
        SUM( INDEX(TodayArray,SEQUENCE(r),c) )
    )
)
ds100's avatar
ds100
Copper Contributor
Feb 25, 2022
Brilliant. I'm going to get a lot of use out of that. Thank you
Lorenzo's avatar
Lorenzo
Silver Contributor
Feb 25, 2022
Glad I could help & you have LAMBDA & Co. + Thanks for providing feedback

Resources