Hi,
I have a list of numbers in A2:A8 and have a formula that produces a cumulative sum in B2:B9. The number 1 is written in B2 and the rest of the numbers are calculated with =B2+A2 in B3 copied down.
What I would like to see is a formula that produces the values in B2:B9 using a dynamic array formula that spills the results in the range starting at B2 and doesn't need to be copied down. Any ideas?
# Cumulative 3 1 4 4 6 8 1 14 13 15 8 28 2 36 38
Best regards,
Marbleking
Bookmarks