Forum Discussion
sumif horiztonally and vertically
how can i update my formula in the summary tab such that when i drag my formula down it finds the month and pulls in the correct column from the raw data tab.
I offer a 365 solution with a dynamic array:
=LET(
GetTotals, LAMBDA(r, c,
LET(
month, INDEX(totals, , r),
div, RIGHT(division) * 1,
filtered, FILTER(month, div = c, 0),
SUM(filtered)
)
),
MAKEARRAY(12, 2, GetTotals)
)