Return of the Corkscrew with Spilled Arrays

I'm starting a new topic but do want to refer to PeterBartholomew1 post on accumulators here https://techcommunity.microsoft.com/t5/excel/ways-of-performing-accumulation-with-dynamic-arrays/m-p/...

Issue08.xlsx19 KB

excel

Formulas and Functions

djclements

Oct 23, 2024

James_Buist Just for good measure, MMULT can also get the job done with minimal effort.

Closing Balance (cell G22):

=LET(
    data, HSTACK(F22:F24,G12:M14+G17:M19),
    cId, SEQUENCE(,COLUMNS(data)),
    arr, MMULT(--data,--(DROP(cId,,1)>=TOCOL(cId))),
    VSTACK(arr,BYCOL(arr,SUM))
)

Cheers!

djclements

Silver Contributor

Dec 18, 2025

You're welcome, Peter!

You may also want to change your profile settings, if you haven't already done so, to disable the default "threaded" conversation view. Under My Settings > Preferences > Replies and Comments, change Display format to Linear and Default sort order to Newest to Oldest.

Sergei was kind enough to point this out to me in another thread.

PeterBartholomew1

Silver Contributor

Dec 20, 2025

Useful. Thanks!

Forum Discussion

Return of the Corkscrew with Spilled Arrays

Resources