# How to Count Cells with Text in Google Sheets (3 Examples)

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.