Countifs with partial match

Fazila

Board Regular
Joined
Nov 19, 2014
Messages
163
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
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,473
Office Version
365
Platform
Windows
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).
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,473
Office Version
365
Platform
Windows
You are welcome.
Glad I was able to help!
:)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,992
Messages
5,471,869
Members
406,791
Latest member
Crones8

This Week's Hot Topics

Top