September 27, 2016
Hi fellow Excel Addict,
Thanks for joining me today for another 'Excel in Seconds' tip. I hope you will find today's tip, 'Summing The Same Cell Across Multiple Sheets' helpful.
If you missed last Thursday's 'Excel in Minutes' tip, 'Split Multi-Row Cell Contents Into Separate Cells', you can read it here now.
Please feel free to share my newsletter with your friends — chances are they will thank you for it.
Hope you have a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Summing The Same Cell Across Multiple Sheets
Often we have workbooks where all of the sheets have an identical layout, for example, monthly reports.
Whenever you want to sum the same cell from multiple sheets here are the steps you need to take.
In the example below, we are going to put a SUM formula in cell C4 of the Summary sheet that will give total of cell D7 from the sheets Jan, Feb and Mar.
1) First, select the cell where you want to put the total;
2) On the Home tab, click the AutoSum command (or use the keyboard shortcut ALT+=);
3) Next, click the tab of the first worksheet you want to sum;
4) Hold down the SHIFT key and click the last sheet tab. All of the sheets in between will be selected. (If you want to sum only specific sheets, instead of the SHIFT key, hold down the CTRL key and click each sheet tab you want to include in your SUM formula);
5) Now, select the cell that you want to sum. You need to do this only on one sheet;
6) Finally, press Enter.
The values from that one cell on all the selected sheets will be summed.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630