Table of Contents
The COUNTIF function in Google Sheets allows users to count the number of cells within a given range that meet a specific criteria. It is possible to use the OR operator within the COUNTIF function to count cells that meet multiple criteria at once. This function is useful for quickly analyzing and organizing data in a spreadsheet, and can be implemented by using the correct syntax and logical operators.
Use COUNTIF with OR in Google Sheets
Often you may want to count the number of cells in a range in Google Sheets that meet one of several criteria.
You can use the following basic syntax to do so:
=ArrayFormula(SUM(COUNTIF(A:A,{"Value1","Value2", "Value3"})))
This particular formula counts the number of cells in column A that are equal to “Value1”, “Value2”, or “Value3.”
The following example shows how to use this syntax in practice.
Example: Use COUNTIF with OR in Google Sheets
Suppose we have the following data in Google Sheets:
We can use the following formula to count the number of cells in column A that have a value of “East” or “South”:
=ArrayFormula(SUM(COUNTIF(A:A,{"East","South"})))
The following screenshot shows how to use this formula in practice:
We can see that a total of 5 cells have a value of “East” or “South” in column A.
We can also use the following formula to count the number of cells in column C that have a value of 95, 99, or 103:
=ArrayFormula(SUM(COUNTIF(C:C,{95, 99, 103})))
The following screenshot shows how to use this formula in practice:
Additional Resources
The following tutorials explain how to perform other common COUNTIF() operations in Google Sheets:
Cite this article
stats writer (2024). How Can I use the COUNTIF function with OR in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/can-i-use-the-countif-function-with-or-in-google-sheets/
stats writer. "How Can I use the COUNTIF function with OR in Google Sheets?." PSYCHOLOGICAL SCALES, 2 Jul. 2024, https://scales.arabpsychology.com/stats/can-i-use-the-countif-function-with-or-in-google-sheets/.
stats writer. "How Can I use the COUNTIF function with OR in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/can-i-use-the-countif-function-with-or-in-google-sheets/.
stats writer (2024) 'How Can I use the COUNTIF function with OR in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/can-i-use-the-countif-function-with-or-in-google-sheets/.
[1] stats writer, "How Can I use the COUNTIF function with OR in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How Can I use the COUNTIF function with OR in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.