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

Top