COUNTIF using excell to count based on 2 conditions

Question

back again for some excel help.

I am trying to calcuate the total number of #N/A or red cells while also checking if they are a teacher.

It will only count the value when the category is teacher. I have tried using the followng function but cannot count based on both conditions. I can get the count indivdually but not together

Is there a way in which I can add the second condition to count a color?

THanks in advance

Answer 1

You can use:

=SUMPRODUCT((C2:C9=G11)*ISERROR(D2:D9))