Table of Contents
SUMIF is a function in Google Sheets that allows users to sum values in a given range based on specific criteria. To use SUMIF from another sheet, the user must first specify the range and criteria in the formula, followed by adding the sheet name and an exclamation mark before the range. This will allow the function to sum data from a different sheet within the same spreadsheet. By using this method, users can easily sum data from multiple sheets without having to manually input the data into a single sheet.
Google Sheets: Use SUMIF From Another Sheet
You can use the following basic syntax to use a SUMIF from another sheet in Google Sheets:
=SUMIF(Sheet1!B2:B11, ">10")
This particular formula takes the sum of values in the range B2:B11 on the sheet titled Sheet1 only if the values are greater than 10.
The following examples show how to use this syntax in practice.
Example 1: SUMIF From Another Sheet
Suppose we have the following sheet named Sheet1 in Google Sheets that contains some data about basketball players:
Now suppose we’d like to switch to Sheet2 and take the sum of the points for the players who have more than 10 points.
We can use the following syntax to do so:
=SUMIF(Sheet1!B2:B11, ">10")
Here’s how to apply this formula in practice:
We can see that the sum of the points values for players who scored more than 10 points is 41.
Example 2: SUMIFS From Another Sheet
Suppose we have the following sheet that contains some data about basketball players:
Now suppose we’d like to switch to Sheet2 and take the sum of the points values for the players who are on team A and have less than 10 points.
=SUMIFS(Sheet1!B2:B11,Sheet1!A2:A11,"A",Sheet1!B2:B11,"<10")
Here’s how to apply this formula in practice:
We see that the sum of points scored among players on team A who had less than 10 points is 22.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I use SUMIF from another sheet in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-sumif-from-another-sheet-in-google-sheets/
stats writer. "How can I use SUMIF from another sheet in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-sumif-from-another-sheet-in-google-sheets/.
stats writer. "How can I use SUMIF from another sheet in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-sumif-from-another-sheet-in-google-sheets/.
stats writer (2024) 'How can I use SUMIF from another sheet in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-sumif-from-another-sheet-in-google-sheets/.
[1] stats writer, "How can I use SUMIF from another sheet in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use SUMIF from another sheet in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.