Need to report a count that meets multiple criteria.

  • Thread starter Thread starter tkm
  • Start date Start date
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
 
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"
 
Back
Top