Table of Contents
The COUNTIF function in Google Sheets allows users to count the number of cells within a range that meet a specific criteria. This function can also be used to count cells in a different sheet within the same spreadsheet. To do so, the user must first specify the sheet name followed by an exclamation mark (!) before selecting the range for the COUNTIF function. This will enable the function to search for and count cells in the specified sheet. This feature is particularly useful for organizing and analyzing data from multiple sheets in a single spreadsheet.
Google Sheets: Use COUNTIF From Another Sheet
You can use the following basic syntax to use a COUNTIF from another sheet in Google Sheets:
=COUNTIF(Sheet1!A1:B20, ">10")
The following examples show how to use this syntax in practice.
Example 1: COUNTIF 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 count the total players who have more than 30 points.
We can use the following syntax to do so:
=COUNTIF(Sheet1!B2:B9, ">30")
Here’s how to apply this formula in practice:
We can see that 2 players have more than 30 points.
Example 2: COUNTIFS 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 count the total players who are on team A and have more than 30 points.
We can use a COUNTIFS function to do so since we’re using multiple criteria when counting:
=COUNTIFS(Sheet1!A2:A9, "A", Sheet1!B2:B9, ">30")
Here’s how to apply this formula in practice:
We can see that 3 players belong to team A and have more than 30 points.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I use the COUNTIF function from another sheet in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-countif-function-from-another-sheet-in-google-sheets/
stats writer. "How can I use the COUNTIF function from another sheet in Google Sheets?." PSYCHOLOGICAL SCALES, 6 May. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-countif-function-from-another-sheet-in-google-sheets/.
stats writer. "How can I use the COUNTIF function from another sheet in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-countif-function-from-another-sheet-in-google-sheets/.
stats writer (2024) 'How can I use the COUNTIF function from another sheet in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-countif-function-from-another-sheet-in-google-sheets/.
[1] stats writer, "How can I use the COUNTIF function from another sheet in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, May, 2024.
stats writer. How can I use the COUNTIF function from another sheet in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.