Summing up a code from multiple sheets in the same workbook

Question

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 I want. Any help much appreciated.

mathetes · Answer

Helen15&nbsp;&nbsp;Since the source sheets contain exactly the same codes in exactly the same order, it would seem that you don't need SUMIF. A simple SUM function works.=SUM(a:d!B3)copied down.&nbsp;So unless your actual need is not what your example illustrated, you've been making it more complicated than need be.

helen15 · Answer

mathetes&nbsp; thank you for your reply however the excel workbook was just an example the proper file I need help with the codes are not in the same order and hence this calculation would not work. Thank you though&nbsp;

patrick2788 · Answer

Helen15&nbsp;If you have Excel 365, you could stack the sheets and summarize.&nbsp;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)
)

Forum Discussion

Summing up a code from multiple sheets in the same workbook

3 Replies

Resources