Count number of cells that contain specific text
I am trying to work out the formula to count the number of cells that contain specific text (eg "FG"). The cells may contain more than the specific text so I want to ensure that any cell with the text is included. Some of the cells may contain text with an extension such as "FGL". If possible, I would like to exclude "FGL" from any "FG" count. The "FG" may be anywhere in the cell.
I am referencing a single column that exists in an alternate sheet as well.
Some examples of text in the cells:
Hopefully that makes sense.
Help Article Resources
Check out the Formula Handbook template!