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
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.
This works great..
Thank you!
Don’t have an account yet? Register yourself now and be a part of our community!