Wildcards with Sumproduct?

H

Hilton

Hi, can I use wildcards with sumproduct?

eg

3A22 8
3B11 6
3B12 12

Would like agrregate 3B11 & 3B12

3B = 18

Thanks
 
J

JLatham

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

Pete_UK

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
 
B

Bob Phillips

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)
 
B

Bob Phillips

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)

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

Pete
 
Top