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>