View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sunil Mariyappa Sunil Mariyappa is offline
external usenet poster
 
Posts: 1
Default How do I get the count in excel based on criteria in multiple col

I need to get the count based on the criteria in two columns, In the below
example I am looking for a formula that will give me the count for defects
that are having the status of OPEN and of CRITICAL severity

Defect# Status Severity
1 Open Critical
2 Closed Showstopper
3 Open Important
4 Closed Critical
5 Open Minor
6 Open Critical
7 Closed Showstopper
8 Open Important
9 Closed Critical
10 Open Minor

Thanks in advance