Wildcard in SUMPRODUCT

[thehog6929]

Hey I'm trying to count multiple creiteria and display in a cell. I'm using SUMPRODUCT to achieve this but it won't accept wildcard characters. My Questions are:
1. Can I use a wildcard character somehow?
2. Can I use a named range instead of A1:A15 e.g.?

Here's an example:

=SUMPRODUCT(--(A15:A106="Michelle"),--(E15:E106="Rez*"))

Thanks in advance!!

[Bob Phillips]

=SUMPRODUCT(--(Names="Michelle"),--(ISNUMBER(SEARCH("Rez",Places))))

[thehog6929]

the criteria is not numerical, so do I need the IsNumber? What do Search and Places represent?

[Bob Phillips]

The ISNUMBER refers to the result of the SEARCH, not to the values being tested.

Names and Places refer to the ranges being checked.

[thehog6929]

Excel doesn't seem to like the named ranges nor the wildcard being used in the formula. Thanks for your help though! I appreciate your time.

[Bob Phillips]

Excel has no problem with named ranges here, and we aren't using a wildcard.