=COUNTIF picking up one piece of info out of a cell that contains more info

[benjii19]

I have countif, which works great. However due to the export from our system other values are in the cells that include the text LOW,MED or HIGH meaning no count as it is specifically looking for LOW,MEd or HIGH.

Here is an example of other text/numbers

eg 33 LOW or 67 HIGH

can i modify the formula to pick the LOW,MED,HIGH up?

=COUNTIF(B2:B798,"LOW")
=COUNTIF(B2:B798,"MED")
=COUNTIF(B2:B798,"HIGH")

[Pete_UK]

You can use wildcard characters (i.e. asterisk) with COUNTIF, so you can do this:

=COUNTIF(B2:B798,"*LOW*")
=COUNTIF(B2:B798,"*MED*")
=COUNTIF(B2:B798,"*HIGH*")

Hope this helps.

Pete

[mehmetcik]

Firstly can you please edit your post.

The formulae should be within fx tags

select your formula and click on fx

Secondly you can use wild cards * works as I just tested it and replaces any number of characters, ? should replace a single character.

Please Login or Register  to view this content.

[Pete_UK]

Thanks for the rep, Benjii.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete