Microsoft Office Tutorials and References
In Depth Information
Specifying worksheet names indirectly
In other words, the formula adjusts so that it continues to refer to the original data (and it no
longer sums the first 12 rows of column A). To prevent Excel from changing the cell references, use
the INDIRECT function:
This formula always returns the sum of the first 12 rows in column A.