 # Summing Across Multiple Sheets

In this article, we are going to learn how to calculate the sum across the multiple sheets in Microsoft Excel.

Let’s take an example and understand:-

We have yearly history of football’s games in Excel file for every country and every sheet has details in same cells with the different numbers.  Summary Sheet:- To return total number of wins, we need to calculate sum of wins in all the sheets

• In summary sheet
• Enter the formula in cell B2 to calculate the sum of wins number
• =Sum(Select cell B2 in US sheet and then press Shift key to select the last sheet) and press Enter
• Formula will look as =SUM(US:JAPAN!B2)
• Copy the same formula in the range B2:B8 To return total number of loses, we need to calculate sum of loses in all the sheets of the workbook

• In summary sheet
• Enter the formula in cell C2 to calculate the sum of loses number
• =Sum(Select cell C2 in US sheet and then press Shift key to select the last sheet) and press Enter
• Formula will look as =SUM(US:JAPAN!C2)
• Copy the same formula in the range C2:C8 This is the way we can calculate the sum of the value across multiple sheets in Microsoft Excel. 