COUNTIF formula Help!!!!!!

[Runner10]

I have 2 columns of data. The left column is whether the individual has good or bad behavior. The right column is whether the individual had a positive or negative experience in the emergency room. I have this formula below, which tells me if the one individual had both bad behavior AND a negative emergency room experience.

=IF(AND(BI10=7,AX10=3),"Yes","No")



However, I have over 400 individuals in my study. How can I adjust this formula to tell me how many individuals had both bad behavior AND a negative emergency room experience? I'm thinking I have to add COUNT or COUNTIF into the above formula? But I'm not sure how to set this all up.


Any help would be appreciated. Thank you.

 

[pgc01]

And I dare to think that:

1. =SUMPRODUCT(--(A16:A417=1),1-ISNUMBER(MATCH(B16:B417,ExcludeList,0)))
2. =COUNTIFS(A16:A417,1)-SUMPRODUCT(COUNTIFS(A16:A417,1,B16:B417,ExcludeList))

[1] is faster than [2].

I've not tested it, but I would also agree that you are right.

I was just commenting the "costly".
From what I understood CountIf() and similar functions are, at least now, quite efficient.

 

[Aladin Akyurek]

[...]
I was just commenting the "costly".
From what I understood CountIf() and similar functions are, at least now, quite efficient.

That's good news. I'm curious though whether they are as good as the FREQUENCY function we use in some set ups