Forum Discussion
PapaAustin
Apr 30, 2021Copper Contributor
Looking for Cumulative Sum Formula that returns Dynamic Arrays (i.e. spill-able)
Hello Excel Community, I have a simple row of numbers with a range name called Numbers I'm looking for a spill formula (one that returns a dynamic array) that returns a cumulative sum. I unders...
PapaAustin
Apr 30, 2021Copper Contributor
Hello,
Thanks for looking at my post. But unfortunately, this formula does not spill.
Making it spillable is what makes this particular formula exercise tricky 😞
I'm not sure if there is a good way to do this without using Lambda (which I currently do not have an access for)
Rajesh_Sinha
May 01, 2021Iron Contributor
Please share some sample data along with the expected output,,, otherwise what I've suggested & by SergeiBaklan are working for Cumulative Sum as you have mentioned with the post !!