View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default COUNTIF with two criteria

See response in public.excel

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Boran Düzgün" wrote in message
...
How can i count rows with two criteria. I can use COUNTIF with only one
criteria... does it posible to count with two criteria..

For example, I need to count the A's in the column A1:A100 which satisfies
the condition "O" in column D1:D100.