Sum Calculation with INDIRECT Formula
Sum Calculation with INDIRECT Formula is preferred in dynamic reporting. Additionally this Excel file enables sheet names to be included in summation
Excel Template for Sum Calculation with Indirect Formula
Sum Calculation with INDIRECT Formula is preferred in dynamic reporting. Additionally this Excel file enables sheet names to be included in summation as text. Because the formula combines INDIRECT and SUM functions, flexibility is ensured. Thus multi-sheet sums are produced in a flexible manner. Therefore the file is used by advanced users.
Hope it is useful.