COUNTIF - First char is S, Second can be any number, but not a letter

  • I need to perform a count when the text in the cell starts with a set letter (in this case "S"), but the 2nd charector must be a number, not a letter.

    Any help would be much appreciated.


  • You could use:


    for example.

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!