wild card in SUMPRODUCT formula
 

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

wild card in SUMPRODUCT formula
 

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

wild card in SUMPRODUCT formula
 

In article ,
Tmt wrote:

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


Try...

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

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

wild card in SUMPRODUCT formula
 

Try

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

If this post helps click Yes
---------------
Jacob Skaria


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

wild card in SUMPRODUCT formula
 

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

wild card in SUMPRODUCT formula
 

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


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

wild card in SUMPRODUCT formula
 

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


"Teethless mama" wrote:

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


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

wild card in SUMPRODUCT formula
 

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

tmtu

"Luke M" wrote:

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

wild card in SUMPRODUCT formula
 

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

Pete

On Aug 31, 3:51*pm, 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*"))