Count number of cells that contain specific text

kat_h
kat_h
edited 12/09/19 in Formulas and Functions

Hi,

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:

- FG

- FGL

- DR

- FG/DR

- DR/FG

- FGL/DR

Hopefully that makes sense.

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!