Using countif with Mid

[Guest]

Is it possible to create a countif statement that will look for a specific
word in an array of text strings?

I tried =COUNTIF(A3:A200,MID(A3:A200,44,5)="Word") where Word is what I am
looking for. Unfortunately this does not work. It returns 0. I also tried
it with ctrl + alt + enter and get the same result.

Thanks

 

[Don Guillett]

try. NO need to array enter. You may have to play with the 44 vs 45
=SUMPRODUCT((MID(B5:B8,45,4)="word")*1)

 

[Guest]

This worked great. Thanks

try. NO need to array enter. You may have to play with the 44 vs 45
=SUMPRODUCT((MID(B5:B8,45,4)="word")*1)

 

[Don Guillett]

glad to help