Forum Discussion
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...
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.
So unless your actual need is not what your example illustrated, you've been making it more complicated than need be.
