Hi, can I use wildcards with sumproduct?

eg

3A22 8
3B11 6
3B12 12

Would like agrregate 3B11 & 3B12

3B = 18

Thanks

Not wild card, but you can use regular string functions. Try this:
=SUMPRODUCT(--(LEFT(A1:A3,2)="3B"),--(B1:B3))

"Hilton" wrote:

Hi, can I use wildcards with sumproduct?

eg

3A22 8
3B11 6
3B12 12

Would like agrregate 3B11 & 3B12

3B = 18

Thanks

In this case you would use a condition like:

(LEFT(A1:A100,2)="3B")

so you probably want something like:

=SUMPRODUCT(--(LEFT(A1:A100,2)="3B"),B1:B100)

Hope this helps.

Pete

On Aug 29, 9:29*am, "Hilton" wrote:
Hi, can I use wildcards with sumproduct?

eg

3A22 * *8
3B11 * *6
3B12 * *12

Would like agrregate 3B11 & 3B12

3B = 18

Thanks

What's wrong with

=SUMIF(A:A,"3B*",B:B)

Not a SUMPRODUCT in sight

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hilton" wrote in message
...
Hi, can I use wildcards with sumproduct?

eg

3A22 8
3B11 6
3B12 12

Would like agrregate 3B11 & 3B12

3B = 18

Thanks

Well, Bob, the OP did specifically ask about sumproduct !! <bg

Pete

On Aug 29, 10:21*am, "Bob Phillips" wrote:
What's wrong with

=SUMIF(A:A,"3B*",B:B)

Not a SUMPRODUCT in sight

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hilton" wrote in message

...



Hi, can I use wildcards with sumproduct?

eg

3A22 * *8
3B11 * *6
3B12 * *12

Would like agrregate 3B11 & 3B12

3B = 18

Thanks- Hide quoted text -

- Show quoted text -

He did Pete, but we can set him right <g

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Pete_UK" wrote in message
...
Well, Bob, the OP did specifically ask about sumproduct !! <bg

Pete

On Aug 29, 10:21 am, "Bob Phillips" wrote:
What's wrong with

=SUMIF(A:A,"3B*",B:B)

Not a SUMPRODUCT in sight

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Hilton" wrote in message

...



Hi, can I use wildcards with sumproduct?

eg

3A22 8
3B11 6
3B12 12

Would like agrregate 3B11 & 3B12

3B = 18

Thanks- Hide quoted text -

- Show quoted text -