CountIf Occurrence in column if value in other column is

[MrDeep]

Imagine First column is A 2nd is B

I use =COUNTIF(B1:B9,“Bad”) to find all occurences of Bad in Column B.

Now I want to find all occurences of Bad in column B but column A has a certain name AA in the same row as the found Bad in column B. So occurence should be 1 since theres only one AA that is bad.

[EarnestAl]

=COUNTIFS(A1:A9,"AA",B1:B9,"Bad")

Cheers, Al

[MrDeep]

That works, thanks!

[anon73440385]

@MrDeep - I that works for you, please click the check mark next to the answer to indicate this fact.