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 -