Calc: wildcard use to intercept a string

users
#1

HI,
ho can I match the string XYZ in a cell?

Example: count.if(interval; XYZ )

string ---> result

XZ 0

GXYZ 1

GXP 0

AABXYZC 1

Thank you !