View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jmrd
 
Posts: n/a
Default Excel Formula with two clauses

How can I enter a formula in excel that counts two text clauses. For instance:
If range A1:A50=John AND range B1:B50=Smith, count 1?