SUMIFS with OR wildcard

[MartinL]

I am stuck trying to do a sumifs where a partial match = set criteria

Price Group	Country	Volume
A <100 - 499	GB	1790
B 500 - 1000	GB	5232
C 1001 - 2000	DE	9958
C 1001 - 2000	GB	4556

<tbody>
</tbody>

so If i want to sum the volume where price group >= 500
I'm thinking along the lines of using 1st characters of Col A [Price Group] like below

I've tried

=SUM(SUMIF(C:C,{"B*","C*"},A:A))

but it doesn't work.....obviously being dim somewhere

I'm quite happy to use SUMPRODUCT or anything else

 

[Fluff]

You've got you columns the wrong way round, try
=SUM(SUMIF(A:A,{"B*","C*"},C:C))

 

[MartinL]

You've got you columns the wrong way round, try

Ugggh of course I have!!!

Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback