Mike,

Column A contains the numerical value for ranks - listed as 1 -10 and colum
b for he gender.

The problem I am having is finding all how many are rank 1 then how many of
each gender

"Mike H" wrote:

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.