Not wild card, but you can use regular string functions. Try this:
=SUMPRODUCT(--(LEFT(A1:A3,2)="3B"),--(B1:B3))

"Hilton" wrote:

Hi, can I use wildcards with sumproduct?

eg

3A22 8
3B11 6
3B12 12

Would like agrregate 3B11 & 3B12

3B = 18

Thanks