You can use the following methods to count cells with a particular text in Google Sheets:
Method 1: Count Cells with Any Text
=COUNTA(A1:A10)
Method 2: Count Cells with Specific Text
=COUNTIF(A1:A10, "Text")
Method 3: Count Cells with One of Specific Texts
=ArrayFormula(SUM(COUNTIF(A:A,{"Text1", "Text2"})))
The following examples show how to use each method with the following dataset in Google Sheets:
Example 1: Count Cells with Any Text
We can use the following formula to count the number of cells with any text in column A:
=COUNTA(A2:A12)
The following screenshot shows how to use this formula in practice:
We can see that there are 8 cells with any text in column A.
Example 2: Count Cells with Specific Text
We can use the following formula to count the number of cells with the text “A” in column A:
=COUNTIF(A2:A12, "A")
The following screenshot shows how to use this formula in practice:
We can see that there are 2 rows with the text “A” in column A.
Example 3: Count Cells with One of Specific Texts
We can use the following formula to count the number of cells with the text “A” or “B” in column A:
=ArrayFormula(SUM(COUNTIF(A:A,{"A", "B"})))
The following screenshot shows how to use this formula in practice:
We can see that there are 5 rows with the text “A” or “B” in column A.
Additional Resources
The following tutorials explain how to perform other common operations in Google Sheets:
Google Sheets: How to Filter for Cells that Contain Text
How to Use COUNTIF with OR in Google Sheets
Google Sheets: How to Use SUMIF with Multiple Columns
