View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dave230 dave230 is offline
external usenet poster
 
Posts: 3
Default Countif - Sumproduct

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.