Dynamic Array Cumulative Sum

Hi All,

I need help with a cumulative sum using the new dynamic array functions of O365.

Attached is a sample sheet outling the problem.

I wish to add No of members as at the model start date to the cumulative number of member renewals each month in the array G8# in the array G16#.

The desired results are highlighted in green at the bottom.

The formula currently in G16 works only for the cumulative sum vertically of E16# and I can't seem to adapt it to work horizontally.

I would appreciate some help.

Thanks

Ron

Please try

=E22#+SUBTOTAL(9,OFFSET(G8,ROW(G8:G11)-ROW(G8),,,G4#))

or non volatile

=E22#+TRANSPOSE(MMULT(--(SEQUENCE(COLUMNS(G4#))>=SEQUENCE(1,COLUMNS(G4#))),TRANSPOSE(G8#)))

you may replace G8# with
SEQUENCE(ROWS(tblMemProd[Membership Product]),COLUMNS(G4#),1000,100)

=E22#+TRANSPOSE(MMULT(--(SEQUENCE(COLUMNS(G4#))>=SEQUENCE(1,COLUMNS(G4#))),TRANSPOSE(SEQUENCE(ROWS(tblMemProd[Membership Product]),COLUMNS(G4#),1000,100))))