Using countif with Mid

L

Landmine

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
 
D

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)
 
Top