Forum Discussion
Helen15
Sep 11, 2023Copper Contributor
Summing up a code from multiple sheets in the same workbook
Can someone please help me. I want to sum up several tabs into a main consolidated tab for certain codes and my formula that I thought would work, doesn't. I have attached a file to help explain what...
Patrick2788
Sep 11, 2023Silver Contributor
If you have Excel 365, you could stack the sheets and summarize.
For example:
=LET(
stack, VSTACK(AllSheets),
Sum3D, LAMBDA(row, LET(ID, TAKE(stack, , 1), val, TAKE(stack, , -1), SUM(FILTER(val, ID = row, 0)))),
BYROW(MyIDs, Sum3D)
)