Will She Be Staying In A Hotel With...
News9 mins ago
Excel Autosum Issues
2 Answers
I have a spreadsheet that I manuallu update with a new tab each week to compile figures, I have an autosum set up to calculate from each sheet and put in to one master, is there a solution that Excel will automatically include the next sheet as it's added ? The data is in the same cell on every sheet.
Answers
1 to 2 of 2
Try the following example: 1. Assuming you have a multiple row of Sheets where the first sheet is called "Firstsheet" and the last sheet is called "Lastsheet", plus you have a master sheet that follows on after the "Lastsheet" 2. You require to sum the cell 'A2' in all sheets between (and including) "Firstsheet" to "Lastsheet" 3. In the master sheet use the...
21:42 Thu 25th Jun 2015
Try the following example:
1. Assuming you have a multiple row of Sheets where the first sheet is called "Firstsheet" and the last sheet is called "Lastsheet", plus you have a master sheet that follows on after the "Lastsheet"
2. You require to sum the cell 'A2' in all sheets between (and including) "Firstsheet" to "Lastsheet"
3. In the master sheet use the formula '=SUM(Firstsheet:Lastsheet!A2)' which will sum total all 'A2' cells in all sheets between and including Firstsheet:Lastsheet.
4. If at a future point you then add a new sheet between Firstsheet and Lastsheet, then its 'A2' cell will also be automatically included in the master sheet sum formula.
You can of course change / substitute your own sheet names in place of "Firstsheet" and "Lastsheet" names to match as appropriate. Just make sure that the master is sheet outside the sum sequence.
1. Assuming you have a multiple row of Sheets where the first sheet is called "Firstsheet" and the last sheet is called "Lastsheet", plus you have a master sheet that follows on after the "Lastsheet"
2. You require to sum the cell 'A2' in all sheets between (and including) "Firstsheet" to "Lastsheet"
3. In the master sheet use the formula '=SUM(Firstsheet:Lastsheet!A2)' which will sum total all 'A2' cells in all sheets between and including Firstsheet:Lastsheet.
4. If at a future point you then add a new sheet between Firstsheet and Lastsheet, then its 'A2' cell will also be automatically included in the master sheet sum formula.
You can of course change / substitute your own sheet names in place of "Firstsheet" and "Lastsheet" names to match as appropriate. Just make sure that the master is sheet outside the sum sequence.
1 to 2 of 2
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.