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
but it doesn't work.....obviously being dim somewhere
I'm quite happy to use SUMPRODUCT or anything else
[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
Code:
=SUM(SUMIF(C:C,{"B*","C*"},A:A))
I'm quite happy to use SUMPRODUCT or anything else
Last edited: