Rolling 12 Months Array Sum

[HeadyFinance]

Hi All,

I have an issue with an array formula that I want to use, summing the past twelve months values in an array based on the relative position in the array.

Since data for twelve months isn't available for the dates 2019-01-01 to 2019-11-01, these should return an error. The months onward however, I would like to sum the value range from an offset position of 11 months back all the way to the current month.

I can achieve it with a very simple regular formula, but I would like it to dynamically change its width as the array with the dates and values expand. This is the desired output with a regular formula, dragged across the array width.

Any genius out there that can help me? Have tried AI assistance but to no avail.

Thank you!

 

[Fluff]

How about

=MAP(SEQUENCE(,COLUMNS(C2#)),LAMBDA(m,IF(m<12,0,SUM(TAKE(TAKE(C3#,,m),,-12)))))

 

[HeadyFinance]

How about

=MAP(SEQUENCE(,COLUMNS(C2#)),LAMBDA(m,IF(m<12,0,SUM(TAKE(TAKE(C3#,,m),,-12)))))

This is wonderful - thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.