My objective is to make this more dynamic. I may have the need to put the *
in one or more of the columns.

"Max" wrote:

Why not just: =SUMPRODUCT((B2:B4=B6)*(C2:C4=C6))

Or: =SUMPRODUCT((A2:A4<"")*(B2:B4=B6)*(C2:C4=C6))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Jim" wrote in message
...
I would like to use a wildcard character with a sumproduct formula.
Data
1 A B C
2 Joe CA 01
3 Sue MA 01
4 Dan CA 02

6 * CA 01
=Sumproduct((A2:A4=A6)*(B2:B4=B6)*(C2:C4=C6))
With "*" in cell A6 I expect to get a result of 1 but instead I get 0. Any
suggestions?
Thanks