COUNTIFS with variable Columns (dates)

Buck4145

New Member
Joined
Sep 10, 2014
Messages
13
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,119,085
Messages
5,576,027
Members
412,694
Latest member
Deaf1Too
Top