Site icon ExcelNotes

How to Count Cells that are a Text String

Please check here if you want to count the number of cells with the text that is part of the cell. The following formula is to count the number of cells with the text string for full text in the cells.

Example: You are working on a worksheet with the animals in column A.

Formula: How many cells are with the word "dog" in the worksheet?

=COUNTIF(A2:A12,"Dog")

The result returns 6, so there are six cells with the word "dog". Please note that the COUNDIF function is not case-sensitive, so"Dog" and "dog" are treated as the same.

Notes: The COUNTIF function

Formula:

= COUNTIF(Range, "Text")

Explanations:

– The range is required, the range of cells you want to count.

Exit mobile version