Counting specific entry from a multiple choice coloumns

[DanMoric]

Hi,

I need help counting specific entry from a multiple criteria and from a multiple columns.

First criteria is one column multiple choice (example: 5th, 6th, 7th, 8th grade)

Second criteria consist out of two columns and each of the columns also have a multi choice (example: english, german, russian, french). 

I need to calculate how many students from each of the grades are attending which class.

I tried with the COUNTIFS formula, and this is an example for the 5th graders that should be attending english =COUNTIFS(B3:B230, "*Fifth*", C3:D230, "*English*") but the result is an error. If I use only one column for the second criteria =COUNTIFS(B3:B230, "*Fifth*", D3:D230, "*English*") I get the result I need

Thanks in advance

Dan

[#2]

@DanMoric 

Hi Dan,

COUNTIFS doesn't work on multiple columns. You may use

=COUNTIFS(B3:B230, "*Fifth*", C3:C230, "*English*")+COUNTIFS(B3:B230, "*Fifth*", D3:D230, "*English*")

if that's OR condition

[#3]

@Sergei Baklan 

Thanks!! That is it!!

[#4]

@DanMoric , you are welcome