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