Table of Contents
The SUMIF function in Excel allows users to add up values from a specific range of cells that meet a certain criteria. This function can also be used across multiple sheets in a workbook by referencing the sheet names and cell ranges in the formula. This allows users to easily calculate the sum of data from different sheets without the need for manual input. By using the SUMIF function across multiple sheets, users can efficiently analyze and consolidate data from different sources in one place. This can save time and improve the accuracy of calculations in Excel.
Excel: Use SUMIF Across Multiple Sheets
You can use the following basic syntax to use SUMIF across multiple multiple sheets in Excel:
=SUMIF(First!B2:B11, "Guard", First!C2:C11)+SUMIF(Second!B2:B8, "Guard", Second!C2:C8)
This particular example will sum all of the following values:
- The values in the range C2:C11 of the sheet titled First only where the corresponding cells in the range B2:B11 contain “Guard”.
- The values in the range C2:C8 of the sheet titled Second only where the corresponding cells in the range B2:B18 contain “Guard”.
The following example shows how to use this formula in practice.
Example: How to Use SUMIF Across Multiple Sheets in Excel
Suppose we have a sheet titled First that contains information about the best pro basketball players during the first half of the regular season:
And suppose we have another sheet titled Second that contains information about the best pro basketball players during the second half of the regular season:
Suppose we would like to calculate the sum of points for players in both sheet who have a value of “Guard” in the Position column.
We can type the following formula into the sheet called Summary to calculate this sum:
=SUMIF(First!B2:B11, "Guard", First!C2:C11)+SUMIF(Second!B2:B8, "Guard", Second!C2:C8)
The following screenshot shows how to use this formula in practice:
The formula returns a value of 176.
This tells us that the sum of values in the Points column for all players who have a value of “Guard” in the Position column in the First and Second sheets is 176.
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2026). How to Sum Values Across Multiple Sheets in Excel Using SUMIF. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-sumif-function-across-multiple-sheets-in-excel/
stats writer. "How to Sum Values Across Multiple Sheets in Excel Using SUMIF." PSYCHOLOGICAL SCALES, 26 Feb. 2026, https://scales.arabpsychology.com/stats/how-can-i-use-the-sumif-function-across-multiple-sheets-in-excel/.
stats writer. "How to Sum Values Across Multiple Sheets in Excel Using SUMIF." PSYCHOLOGICAL SCALES, 2026. https://scales.arabpsychology.com/stats/how-can-i-use-the-sumif-function-across-multiple-sheets-in-excel/.
stats writer (2026) 'How to Sum Values Across Multiple Sheets in Excel Using SUMIF', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-sumif-function-across-multiple-sheets-in-excel/.
[1] stats writer, "How to Sum Values Across Multiple Sheets in Excel Using SUMIF," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, February, 2026.
stats writer. How to Sum Values Across Multiple Sheets in Excel Using SUMIF. PSYCHOLOGICAL SCALES. 2026;vol(issue):pages.