Table of Contents
Summing across multiple sheets in Excel allows you to easily calculate the total of a specific data set that is spread out across different sheets. This can be helpful when working with large amounts of data or when dealing with multiple sets of similar data. To sum across multiple sheets, you can use the SUM function and specify the range of cells from each sheet that you want to include in the calculation. This will provide you with an accurate total of the data from all the specified sheets, saving you time and effort in manual calculations. Overall, summing across multiple sheets in Excel is a convenient and efficient way to analyze and manage data.
Sum Across Multiple Sheets in Excel
You can use the following basic syntax to sum values across multiple sheets in Excel:
=SUM(Sheet1!A1, Sheet2!B5, Sheet3!A12, ...)
The following example shows how to use this syntax in practice.
Example: Sum 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!B2, week2!B2, week3!B2)The following screenshot shows how to use this formula in practice:
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 20 points across the three weeks.
- Player B scored a total of 18 points across the three weeks.
- Player C scored a total of 21 points across the three weeks.
And so on.
=SUM(week1:week3!B2)The following screenshot shows how to use this formula in practice:
Notice that the values for the Total Points column match the ones we calculated earlier.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2024). How can I sum across multiple sheets in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-sum-across-multiple-sheets-in-excel/
stats writer. "How can I sum across multiple sheets in Excel?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-sum-across-multiple-sheets-in-excel/.
stats writer. "How can I sum across multiple sheets in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-sum-across-multiple-sheets-in-excel/.
stats writer (2024) 'How can I sum across multiple sheets in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-sum-across-multiple-sheets-in-excel/.
[1] stats writer, "How can I sum across multiple sheets in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I sum across multiple sheets in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.