Nested COUNTIF or DCOUNT

P

Patricia Martinez

I need to count the number of instances depending on two separate criterias,
for example:

Profile Status
High Accepted
High Accepted
Middle Rejected
Middle Accepted
Low Rejected

I need to know how many "High" profiles have a status of "Accepted" (2), how
many are "High" and have "Rejected" (0), etc.

Any ideas on how I can get this to work?
 
N

NHarkawat

=SUMPRODUCT(--(A2:A6="High"),--(B2:B6="Accepted"))
and so on for the different combibnations
 
Top