Sum with criteria

[colinheslop1984]

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?

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>

 

[andysinclair]

Can you show what the example output would be for this dataset?

It's not too clear from your question and will help people suggest a solution.