Countifs with partial match

[Fazila]

I need a countifs column that will count values in columns that contain the words TA2 and EFG. The column headings are something like "2019: Year 11 TA2 (22 Jan 2019): Mathematics: EFG"

So I need to count any value where the column that contains the words TA2 and EFG and the student has a grade of 7 or above. I've tried using =COUNTIFS(SubHeads,"*TA2*"&"EFG",BN2:IS2,">=7") but come up with a #value .

Thanks in advance.

Fazila

 

[Joe4]

With COUNTIFS, you can test multiple conditions. So break this part up into multiple conditions.
First, check your range for the entry "*TA2*".
Second, check the same range for entry "*EFG*"
Third, check any other conditions (looks like you are looking for values greater than 7).

 

[Fazila]

Thanks Joe4 worked great

 

[Joe4]

You are welcome.
Glad I was able to help!