Countif using Wildcard

[howard]

I have descriptions I Col A on sheet "Imported Data"


I have tried to set up a formula to count all the "Landrover Evoque" contained in Col A

Book1
	A
1	LAND ROVER Range Rover Evoque MY16 (vlbv04) 2.0 i4 Diesel Dynamic
2	LAND ROVER Range Rover Evoque MY17 (pubd04) 2.0 Si4 Convertible
3
Imported Data

See my formula on Sheet Summary

Book1
	A	B	C
1	Land Rover Evoque	0
Summary

Cell Formulas
Range	Formula
B1	=COUNTIF('Imported Data'!A:A,"*?"&A1&"*")

it would be appreciated if someone could assist me

 

[Marcelo Branco]

Maybe...

=COUNTIF('Imported Data'!A:A,"*"&SUBSTITUTE(A1," ","*")&"*")

M.

 

[howard]

Thanks for the help. Code works perfectly

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.