Possible alternative:

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tmt" wrote:

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*"))