I'm not 100% sure what you're asking, but I'll give it a shot. If your sheets are named 1-100, then I think =SUM('1:100'!J11) is what you need. Let me know if I misunderstood the question.
I have about 100 worksheets in my excel workbook and each sheet is identical. I would like to create a control sheet that would add the cells of the different worksheets together and place it in the control. I tried doing it manually but found out quickly that it would take forever since I have a about 10 cells that I need to put on the control sheet.
For example on the control sheet in J11 I want to put in: ='1'!J11+'2'!J11......'100'!J11
Is there a faster way to do this? Thanks for your help!
Sorry there, found the solution. So if anybody's looking to do the same:
Instead of sum('1:100'!A1), you take the name of the first sheet you like to sum and the name of the last one, like this:
There are currently 4 users browsing this thread. (0 members and 4 guests)