Multiple Count if and Sum

[degree01]

I currently have the below formula to find out how many A grades a group of Turkish students are getting.

=SUM(COUNTIFS(Ethnicity,{"Turkish","Turkish Cypriot","Kurdish"},I2:I84,{"A"}))

Now I need to find out how many of them are getting grades A and B from a Column. I entered the below formula, it doesn't count "B".

=SUM(COUNTIFS(Ethnicity,{"Turkish","Turkish Cypriot","Kurdish"},I2:I84,{"A","B"}))

Please help

 

[cyrilbrd]

I currently have the below formula to find out how many A grades a group of Turkish students are getting.

=SUM(COUNTIFS(Ethnicity,{"Turkish","Turkish Cypriot","Kurdish"},I2:I84,{"A"}))

Now I need to find out how many of them are getting grades A and B from a Column. I entered the below formula, it doesn't count "B".

=SUM(COUNTIFS(Ethnicity,{"Turkish","Turkish Cypriot","Kurdish"},I2:I84,{"A","B"}))

Please help

Please consider this:

=SUM(COUNTIFS(Ethnicity,{"Turkish","Turkish Cypriot","Kurdish"},I2:I84,{"A";"B"}))

 

[degree01]

Cyrilbrd thank you, the formula works.

 

[cyrilbrd]

Cyrilbrd thank you, the formula works.

Most welcome.
Thanks for the feedback.