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.

And so on.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Use SUMIF Across Multiple Sheets

Excel: How to Calculate the Sum by Group

Excel: How to Sum Values by Month and Year