colinheslop1984
Board Regular
- Joined
- Oct 14, 2016
- Messages
- 129
- Office Version
- 2016
I have a table of data which when downloaded from its external source looks a bit like this.
is there a formula that can perform a sumifs when the criteria 1 is in column A running vertical (i.e. the rank numbers) but criteria 2 is also in column a but the word womens, so it needs to add up any data that appears below womens but then stops at mens?
<tbody>
</tbody>
is there a formula that can perform a sumifs when the criteria 1 is in column A running vertical (i.e. the rank numbers) but criteria 2 is also in column a but the word womens, so it needs to add up any data that appears below womens but then stops at mens?
rank | style name | qty | value |
womens | |||
1 | poppy | 6 | 377 |
2 | edie | 3 | 180 |
3 | zoe | 3 | 165 |
mens | |||
1 | slim straight | 3 | 160 |
2 | pembroke | 1 | 95 |
3 | mayland | 1 | 70 |
<tbody>
</tbody>