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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct and Wildcards 4
Sumproduct help please! 1
SUMPRODUCT WITH WILDCARD 5
Sumproduct if two conditions are met but using wildcards? 5
Count cells containing text, multiple criteria 2
'Substitute' function with wildcards 1
2007 conditional formatting begins with 1
Global find and replace in Excel 2007 1

Top