COUNTIFS to count when a cell contains any version of a word I want to count

Girv · 08/08/18

How do I indicate that I would like to count any time the cell has "DESIGN" in it whether the cell says exactly "DESIGN" or "re-DESIGN"?

J. Craig Williams · 08/08/18

Something like this:

=COUNTIFS( range , FIND("DESIGN", UPPER(@cell)) > 0)

where range is likely a column reference. This will also count "design" and "re-design". If you don't need that, remove the UPPER()

Craig

Tribeiro · 04/29/19

hi J. Craig

How about if I the range is a different sheet and I need to find the number 17 in.

=COUNTIFS({Range 4}, FIND("17", @cell))

or

=COUNTIF(FIND("17", {Range 4}))

Comments