wild card in SUMPRODUCT formula

[Tmt]

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

 

[Luke M]

Possible alternative:

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

 

[Domenic]

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

Try...

=SUMPRODUCT(--('Q3'!E12:E153="Calibrated"),--(LEFT('Q3'!G12:G153,5)="7022
2"))

 

[Jacob Skaria]

Try

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

If this post helps click Yes

 

[Don Guillett]

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

 

[Teethless mama]

correction
=SUMPRODUCT(('Q3'!E12:E153="Calibrated")*('Q3'!G12:G153=70222&{"A","B","C","D","E"}))

 

[Tmt]

This helps out really well. Thanks all that've responded to my request.

tmtu

 

[Pete_UK]

Well, if you had checked your post on 28th August you would have had
your answer 3 days ago.

Pete