try left('Q3'!G12:G153,5)="70222"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tmt" wrote in message
...
Hello,

This SUMPRODUCT won't work with the wildcard * when I tried to count all
the
70222A, B, C, D and E under the "calibrated" condition. Please help.

=SUMPRODUCT(('Q3'!E12:E153="Calibrated")*('Q3'!G12 :G153="70222*"))