Hi
I am using the Indirect function (which works nicely) to Sum three separate tabs on a summary tab. The problem is that when I drag the formula to the other rows and columns in the summary tab, the cell reference doesn't change, even though there are no $ signs to make it absolute.
So...