Forum Discussion
Alternate to SUMIFS array assistance
Hello, everyone. I apologize for asking yet another SUMIFS question, but I haven't been able to find a thread anywhere (so far) that offers a sample similar to what I'm trying to do. I have a...
With dynamic arrays, you could use:
=LET(
category, XLOOKUP(Table2[Item Code], Table1[Item Code], Table1[Category], "None"),
PIVOTBY(Table2[Date], category, Table2[Units], SUM, , 0, , 0)
)
