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?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]rank[/TD]
[TD]style name[/TD]
[TD]qty[/TD]
[TD]value[/TD]
[/TR]
[TR]
[TD]womens[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]poppy[/TD]
[TD]6[/TD]
[TD]377[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]edie[/TD]
[TD]3[/TD]
[TD]180[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]zoe[/TD]
[TD]3[/TD]
[TD]165[/TD]
[/TR]
[TR]
[TD]mens[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]slim straight[/TD]
[TD]3[/TD]
[TD]160[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]pembroke[/TD]
[TD]1[/TD]
[TD]95[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]mayland[/TD]
[TD]1[/TD]
[TD]70[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.