Combining Excel COUNTIFS with aggregate functions
Say I have an Excel spreadsheet containing student details and dates of courses the student attended. Lets say the row headers are:

Name - Student Grade - Date of course A - Date of course B - Date of course C etc...

Then obviously a separate row per student containing their grade and dates of the courses the student was present in. I want to avoid making modifications to the sheet as the format has been established for a while.

I'm looking for some way of counting all the students with a grade a specific grade, which attended courses between specific dates. For example, count all students with a "C" grade, which attended courses between 1st Jan 2012 to 31st March 2012.

I guess the final formula will be some sort of combination of COUNTIFS and MAX on the date range columns, but I can't see how I can apply this on a row-by-row basis.

All suggestions much appreciated!

Best regards,
Chris
Combining Excel COUNTIFS with aggregate functions
===

Say I have an Excel spreadsheet containing student details and dates of courses the student attended. Lets say the row headers are:

Name - Student Grade - Date of course A - Date of course B - Date of course C etc...

Then obviously a separate row per student containing their grade and dates of the courses the student was present in. I want to avoid making modifications to the sheet as the format has been established for a while.

I'm looking for some way of counting all the students with a grade a specific grade, which attended courses between specific dates. For example, count all students with a "C" grade, which attended courses between 1st Jan 2012 to 31st March 2012.

I guess the final formula will be some sort of combination of COUNTIFS and MAX on the date range columns, but I can't see how I can apply this on a row-by-row basis.

All suggestions much appreciated!

Best regards,
Chris