How do I get the count in excel based on criteria in multiple col

  • Thread starter Sunil Mariyappa
  • Start date
S

Sunil Mariyappa

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counts for Excel 2003 using multiple criteria 6
Need to report a count that meets multiple criteria. 2
Formula to count multiple various inputs and create a summary 2
Count based on Conditions 1
Count based on date criteria 1
Count based on multiple criteria 2
Count based on multiple criteria 2
count number of occurences on a particular date 3

Top