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