View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aet999
 
Posts: n/a
Default Count text cells based on two criteria

I have a spreadsheet with many columns. I would like to count how many
occurances there are of two criteria matching. Example, If column A contains
names of girls (amy, betty, susie, karen, betty) and column B contains names
of boys (michael, robert, andrew, james, joseph). how many times does column
A = betty AND column b = robert on the same row? In this example, the answer
would be one.