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...