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
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