How to carry over values from one month to +3 months

Question

I would like to carry over values from one month to +3 months from the given table using formulas in google sheet.

A sheet with sample data and query is below https://docs.google.com/spreadsheets/d/1Pa2HlsG8rDtM6nDe5Ty0JPOYzdvZ2nUu1yGwqW-1tO8/edit#gid=0

The desired result is in 16 and 17 rows.

Many thanks!

Answer 1

You may try:

=makearray(counta(B16:B),counta(C14:N14),lambda(r,c,+ifna(filter(filter(C5:N6,B5:B6=index(B16:B,r)),C4:N4=index(eomonth(edate(C14:N14,-C12),),,c)))))