Forum Discussion
Something off in my settings
I have 12 workbooks, each with 3 worksheets in them. All with column headings as days of the year. I am trying to create a master sheet totaling all of the columns in each workbook and each workshe...
When you copy a formula which points to another worksheet, the "link" to the sheet remains the same, only the cell addresses change. For this problem you might use the INDIRECT function.
Suppose you want to sum cells A1:A10 on each sheet.
Put the names of the worksheets on the summary sheet in -say- cells B2:B10
Now in any cell on row 2 enter this formula:
=SUM(INDIRECT("'"&B2&"'!A1:A10"))
Drag the formula down.
Suppose you want to sum cells A1:A10 on each sheet.
Put the names of the worksheets on the summary sheet in -say- cells B2:B10
Now in any cell on row 2 enter this formula:
=SUM(INDIRECT("'"&B2&"'!A1:A10"))
Drag the formula down.