Hi,

Assuming m or f in column A and a rank in column b put this in a cell and
drag down for as many ranks as you have

=SUMPRODUCT(($A$1:$A$100="M")*($B$1:$B$100=ROW(A1) ))

Change M to F to get the female ranks

Mike

"dave230" wrote:

I need to extract data by searching for a numerical value in one column then
a text value from another column. It is a personnel table with ranks listed
as numerical values then gender as m or f. I need to know how many of each
rank by each gender.