COUNTIFS with variable Columns (dates)

[Buck4145]

Good morning,

I have a spreadsheet that I need to provide stats returns on based on multiple criteria reported by date. I currently have =COUNTIFS('Attendance Tracker'!$H:$H,$A$17,'
Attendance
Tracker'!L:L,$B18) where:

• 'Attendance Tracker'!$H:$H = Syllabus entry​
• $A$17 = Syllabus Type
• 'Attendance Tracker'!L:L = Date column that has Location codes of what school the member attended (this needs to be variable and return against =today()-1 formula)​
• $B18 = Location​

This is replicated
with rows for location
by each Syllabus for each month and then feeds into my return to head office which is an Index Match =INDEX(C64:AF64,MATCH($A$1,$C$61:$AF$61,0)) where:

• the index is the numbers from above by date
• $A$1 = the =today()-1 formula
• $C$61:$AF$61 = Date range.​

If I can combine these 2 functions so that I only need the head office report this would be great.

Thanks in advance