Table of Contents
Summing the same cell across multiple sheets in Excel refers to the process of adding the values of a specific cell from different sheets in a workbook. This can be achieved by using the SUM function, which allows you to specify the range of cells to be added. By doing this, you can easily calculate the total value of a specific cell across all sheets without having to manually input each value. This feature is particularly useful when working with large amounts of data spread across multiple sheets, saving time and improving accuracy in calculations.
Excel: Sum the Same Cell Across Multiple Sheets
You can use the following basic syntax to sum the values in the same cell across multiple sheets in Excel:
=SUM(week1:week3!B2)
This particular formula will calculate the sum of the value in cell B2 for every sheet between the sheets named week1 and week3.
The following example shows how to use this syntax in practice.
Example: Sum the Same Cell Across Multiple Sheets in Excel
Suppose we have three sheets titled week1, week2, and week3 that each contain data about eight basketball players and their total points scored during that week:
Each sheet has the exact same layout with “Player” in column A and “Points” in column B.
Now suppose we’d like to take the sum of points scored for each player during each week and display the sum in a new sheet called total:
We can use the following formula to do so:
=SUM(week1:week3!B2)
We can type this formula into cell B2 of the total sheet and then click and drag this formula down to each remaining cell in column B:
The “Total Points” column contains the sum of the points scored for each player across week1, week2, and week3.
For example:
- Player A scored a total of 29 points across the three weeks.
- Player B scored a total of 12 points across the three weeks.
- Player C scored a total of 24 points across the three weeks.
Additional Resources
The following tutorials explain how to perform other common operations in Excel: