Forum Discussion

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

Feb 25, 2022

ds100

in E3

=MAKEARRAY(
    ROWS(TodayArray), COLUMNS(TodayArray),
    LAMBDA(r,c,
        SUM( INDEX(TodayArray,SEQUENCE(r),c) )
    )
)

Lorenzo

Silver Contributor

Feb 25, 2022

ds100

in E3

=MAKEARRAY(
    ROWS(TodayArray), COLUMNS(TodayArray),
    LAMBDA(r,c,
        SUM( INDEX(TodayArray,SEQUENCE(r),c) )
    )
)

ds100

Copper Contributor

Feb 25, 2022

Brilliant. I'm going to get a lot of use out of that. Thank you

Lorenzo
Silver Contributor
Feb 25, 2022
Glad I could help & you have LAMBDA & Co. + Thanks for providing feedback