View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sarahlbdarling sarahlbdarling is offline
external usenet poster
 
Posts: 1
Default Conditional Formula, counting one criteria in a range based on ano

I have two columns of data, one being gender and the other being nationality.
I want to count how many British males there are, I can get the formulas to
work. I have tried many many variations of counta, countif, countifs, if etc
and none work.....where am I going wrong!