If you want to count the number of cells based on the text that is part of the cell, please check here. 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?
The result returns 6, and there are six cells with the word "dog". Please remember that the COUNDIF function is not case-sensitive, so"Dog" and "dog" are treated as the same.
Notes: The COUNTIF function
= COUNTIF(Range, "Text")
– The range is required, which is the range of cells that you want to count.