Need to report a count that meets multiple criteria.

T

tkm

Help - my brain is fried! This one will be easy for you guys!

I need to report a count of data in cells that meet multiple criteria from
one sheet, and report it on a summary sheet

For example: I need to know how many defects are labeled with a certain
Severity and Status. Critical/Open, Critical/Closed, Critical/Deferred.

Sheet "Defect"
A B C
1 Description Severity Status
2 Defect 1 Critical Open
3 Defect 2 Critical Closed
 
S

Stephen Lloyd

Lets say in a summary section you have Open, Closed, and Critical listed in
e1, f1, and g1.

In e2:
=sumproduct(--(b2:b20="Critical"), --(c2:c20=e1))
f2:
=sumproduct(--(b2:b20="Critical"), --(c2:c20=f1))
g2:
=sumproduct(--(b2:b20="Critical"), --(c2:c20=g1))

e1,f1, and g1 references can be substituted with the actual values in
quotation marks, ie "Open"
 

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
Count based on Conditions 1
Formula to count multiple various inputs and create a summary 2
Summary Counts Functions to filter multiple conditions 2
count number of occurences on a particular date 3
count cells in a table that meet multiple criteria 1
Help with displaying summary please... 1
Counting rows that meet multiple criteria 5

Top