Perhaps something like this?:

For values in A1:B100

B1: =SUMPRODUCT((LEFT(A1:A100,3)="FPP")*(ISNUMBER(SEAR CH("CONN",B1:B100))))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Kevin" wrote:

I want to do a COUNTIF using the text combine in 2 columns.
I tried using concatenate =COUNTIF(A:A&B:B,"FPP*Conn*") but I get an
formula error