Folks,
I am trying to see if I can use a wildcard character type to search for a
textstring within an IF Statement. I know that I can do a filter to return
the rows of a column that meets certain criteria (including "contains",
"begins with", etc.):

If(A1 = "CA*", a1+1,0)

or
Sumif(A1:A10,"CA*", c1:e1)

Any insight will be greatly appreciated.

Regards,
Shams.