Formula looking for criteria, but some cells have the criteria with another criteria

[JGriffo33]

I'm having trouble with a formula looking for a "word" but in some cells it has "word another word"

	A	B
1	FLB	Name
2	FLB CTW	Name
3	CTW	Name
4	FRF	Name
5	2RF FRF	Name

<tbody>
</tbody>

So i'm using a formula that is looking for "FLB". But because some cells have "FLB CTW", it skips these and only uses the cells that have "FLB" only. How do i write the formula to include "FLB" even if it has another word in the cell?

 

[FDibbins]

what do you want the formula to do?

 

[JGriffo33]

The formula I have is working fine, but where I have it searching for "FLB" it doesn't include cells that have "FLB CTW". I can't just put "FLB CTW" in the formula either as down the track I also have "FLB FE" so I just want it to search all cells that have "FLB" in them even if it has more

 

[Anand Sharma]

Hi,

If you want to count similar Text "FLB" or other you can use below formula

=COUNTIF(H3:H7,"*"&H3&"*")

here "*" wildcards used to find matching in text

 

[FDibbins]

The formula I have is working fine,

but I asked - what do you want the formula to do? SUM? COUNT? AVERAGE? What?

If we know what you are trying to do, we can make suggestions on how to do it
Can you show your formula?