Nested COUNTIF or DCOUNT

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

 

[NHarkawat]

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

 

[Frank Kabel]

Hi
try:
=SUMPRODUCT(--(A1:A100="High"),--(B1:B100="Accepted"))

also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Patricia Martinez" <Patricia (e-mail address removed)>
schrieb im Newsbeitrag
news:[email protected]...