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:

We can see that a total of **6** cells have a value of 95, 99, or 103 in column C.

**Additional Resources**

The following tutorials explain how to perform other common **COUNTIF()** operations in Google Sheets:

Google Sheets: How to Use COUNTIF From Another Sheet

Google Sheets: How to Use COUNTIF with Multiple Ranges

Google Sheets: How to Use COUNTIFS with a Date Range