Forum Discussion

ribamero's avatar
ribamero
Copper Contributor
Jan 18, 2023
Solved

COUNTIF cells which contain some letters

Hi everyone!

I want to use the COUNTIF function to count the cells in a range that contain any of three different letters given and in any position of the string, e.g., cells that contain the letters "s" or "a" or "f". Some examples are:

1. sex

2. air

3. fuel

4. fast

5. ants

6. stuff

Can I do that? Thank you!

excel
Formulas and Functions

4 Replies

    • ribamero's avatar
      ribamero
      Copper Contributor
      Jan 19, 2023

      Hi Rodrigo_!
      Thank you for your message.
      Well, in fact, the function that I'm working on is COUNTIFS. I wanted to write an easy example with COUNTIF.
      I'm going to explain my question again using the COUNTIFS function:

      I want to count the cells in the range B1:B10 that begin with letters "G" or "P" and are a COLOR, range A1:A10. Something like this, though I know the criteria is wrong: COUNTIFS(B1:B10;"[G,P]*";A1:A10;"COLOR")

      Regards.

Resources