Need to report a count that meets multiple criteria.
 

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

Need to report a count that meets multiple criteria.
 

Here's some good reading:

http://www.ozgrid.com/Excel/sum-if.htm


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"tkm" wrote:

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

Need to report a count that meets multiple criteria.
 

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"





"tkm" wrote:

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