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.


    TIA

    You could use:


    =SUM(COUNTIF(A1:A100,"S"&{1,2,3,4,5,6,7,8,9,0}&"*"))


    for example.

    Rory
    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

    Love 1

Participate now!

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

Register Yourself Login