Using IF to detect the nth character in a cell

[Colmans]

Hi

I need to amend a formula to run sumifs and countifs. My challenge is that I need to identify a product serial number. The serial number contains two parts, the first part is rigid but the second part is variable. Part of the code I need will always be the 5th and/or 6th characters. If I use a variable string there is a random chance that these characters will appear later in the text

e.g

ABCD24/xx/1234
WXYZ16/xx/1124

I want to identify the first above but if i use "*24*" in my search criteria it will count both

Thanks in advance for feedback and suggestions

 

[AlphaFrog]

Try using "????24*"

 

[Colmans]

Try using "????24*"

Seems to work a charm. Thanks alot

 

[AlphaFrog]

You're welcome. Thanks for the feedback.