Countif for a constant value

[Spockster]

I have a sheet that I am doing a match and a countif the value appears. However the value I am looking for is in the middle of other text. It looks something like this. "Outbond Service - 45879 - Services" and I want to be able to count the constant value of "45879" How can this be done. My formula is
=IF(ISNA(COUNTIF(INDEX('Sheet 1'!$1:$65536,0,MATCH("Position Owner",'Sheet 1'!$1:$1,0)),"*""B5""*")),"0",COUNTIF(INDEX('Sheet 1'!$1:$65536,0,MATCH("Position Owner",'Sheet 1'!$1:$1,0)),"*""B5""*"))

The formula works great but now with the text around my value it doesn't count. Any help would be great.

Thank you

 

[Domenic]

Try changing the criterion for COUNTIF to...

"*"&B5&"*"

Hope this helps!

 

[Domenic]

Also, I think the following would suffice...

=IF(ISNUMBER(MATCH("Position Owner",'Sheet 1'!$1:$1,0)),COUNTIF(INDEX('Sheet 1'!$1:$65536,0,MATCH("Position Owner",'Sheet 1'!$1:$1,0)),"*"&B5&"*"))

Hope this helps!

 

[Spockster]

It worked!! thank you

Thank you for your quick help