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.
A 365 solution for the future with an insider function (hopefully, widely available very soon!):
=LET(
aggregated, GROUPBY(Division, Data, SUM, , 0),
TRANSPOSE(aggregated)
)
That takes the prize for elegance!
I had wondered about normalising the data and then using PIVOTBY but this is far better.