Summing across Multiple Sheets using an indirect formula

**Scorpio** · 10-06-2009, 06:21 PM

Hi

I am busy working on a rather large spreadsheet and i am now busy working on a summary page of all the sheets i have done before and am having a bit of trouble.

I need to sum the same cell reference across approx a dozen different sheets. The position of what i want to sum on the detailed sheets is the same, but the layout on the detailed sheets is not the same as that of the summary - so using a relative formula reference will not work.
The easiest way i can think of is an INDIRECT formula where i tell excel what the cell refernces are and it does the rest for me.

I have had luck the INDIRECT working with it beforehand - but that was only pointing to one sheet, but expanding the formula to include multiple sheets is proving a problem.

I have attached an excel which has a extreme summary of the spreadsheet i am working on and have indicated which cell i am needing the formulae in and from there i can copy/paste into the balance of the cells.

If anyone can help, it'll be greatly appreciated.

**Special-K** · 10-06-2009, 06:35 PM

Try

=SUM('Start->:<-End'!E6)

**DonkeyOte** · 10-07-2009, 05:29 AM

I think the above needs to be modified slightly to cater for the sheet names in the file ?

ie E9: =SUM('Start-->:<--End'!E6)

The above modified per cell will still be significantly more efficient than the alternatives (and non-volatile).