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.

 

image 4

 

image 5

 

Summary Sheet:-

 

image 3

 

To return total number of wins, we need to calculate sum of wins in all the sheets

Follow below steps:-

  • 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

 

image 4
To return total number of loses, we need to calculate sum of loses in all the sheets of the workbook

Follow below steps:-

  • 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

 

image 5

 

This is the way we can calculate the sum of the value across multiple sheets in Microsoft Excel.

 

image 48

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube