View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Boying Opaw Boying Opaw is offline
external usenet poster
 
Posts: 1
Default Count Number of Rows

In a given range, I only want to count the rows when certain columns satisfy
corresponding criterias. How do I do this?

Say I have Rows 1 to 10 and Columns A to D. I only want to count the rows
when the content of A = criteriaA and the content of B = criteriaB. What
formula do I use?