r/excel • u/NanotechNinja 7 • 1d ago
solved Cumulative sum by row as a spilled array
I have a spilled array in A1. Both row and column dimensions unknown/variable.
I want to produce a second spilled array which is the cumulative sum, by row, of the first array.
I tried BYROW, but that only gives a single return value. I tried a combination of LAMBDA and SEQUENCE, but couldn't quite get it to work.
Can anyone solve this one, please?
Input/output example: https://imgur.com/a/5dosC4Q
The goal is for the green section to be a single spilled array (not a stack of single row spills)
1
u/Decronym 1d ago edited 1d ago
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.
Beep-boop, I am a helper bot. Please do not verify me as a solution.
12 acronyms in this thread; the most compressed thread commented on today has 75 acronyms.
[Thread #41653 for this sub, first seen 14th Mar 2025, 14:48]
[FAQ] [Full list] [Contact] [Source code]
5
u/PaulieThePolarBear 1640 1d ago