SUMIFS with OR wildcard

[MartinL]

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Price Group[/TD]
[TD]Country[/TD]
[TD]Volume[/TD]
[/TR]
[TR]
[TD]A <100 - 499[/TD]
[TD]GB[/TD]
[TD]1790[/TD]
[/TR]
[TR]
[TD]B 500 - 1000[/TD]
[TD]GB[/TD]
[TD]5232[/TD]
[/TR]
[TR]
[TD]C 1001 - 2000[/TD]
[TD]DE[/TD]
[TD]9958[/TD]
[/TR]
[TR]
[TD]C 1001 - 2000[/TD]
[TD]GB[/TD]
[TD]4556[/TD]
[/TR]
</tbody>[/TABLE]

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