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 understand there are options for the non-spillable ways to generate the **bleep** such as =sum($a$1:a2) and drag this formula across the row.
Thank you!
","kudosSumWeight":1,"postTime":"2021-04-29T22:21:48.950-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:excel","text":"excel","time":"2016-06-21T14:08:51.129-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}},{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDI","node":{"__typename":"Tag","id":"tag:office 365","text":"office 365","time":"2016-06-27T01:27:02.990-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:2309337_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":25549},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"customFields":[],"body":"
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 understand there are options for the non-spillable ways to generate the **bleep** such as =sum($a$1:a2) and drag this formula across the row.
Thank you!
"},"Conversation:conversation:2309337":{"__typename":"Conversation","id":"conversation:2309337","solved":false,"topic":{"__ref":"ForumTopicMessage:message:2309337"},"lastPostingActivityTime":"2023-06-14T07:15:30.589-07:00","lastPostTime":"2023-06-14T07:15:30.589-07:00","unreadReplyCount":27,"isSubscribed":false},"ModerationData:moderation_data:2309337":{"__typename":"ModerationData","id":"moderation_data:2309337","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:2309337_1":{"__typename":"Revision","id":"revision:2309337_1","lastEditTime":"2021-04-29T22:21:48.950-07:00"},"ForumReplyMessage:message:2310626":{"__typename":"ForumReplyMessage","id":"message:2310626","conversation":{"__ref":"Conversation:conversation:2309337"},"author":{"__ref":"User:user:521"},"revisionNum":1,"uid":2310626,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: Looking for Cumulative Sum Formula that returns Dynamic Arrays (i.e. spill-able)","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:2310626"},"parent":{"__ref":"ForumTopicMessage:message:2309337"},"body":"\n
Picture disappeared. Repeat
\n","body@stringLength":"682","rawBody":"
Picture disappeared. Repeat
\n
