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