I am stuck trying to do a sumifs where a partial match = set criteria
<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
but it doesn't work.....obviously being dim somewhere
I'm quite happy to use SUMPRODUCT or anything else
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
Code:
=SUM(SUMIF(C:C,{"B*","C*"},A:A))
I'm quite happy to use SUMPRODUCT or anything else
Last edited: