Count how many have completed each Training Course within a Date Range
I have one spreadsheet containing all Compliance courses taught this year, and the dates on which the employees have completed them.
Column A = Course Title
Column B = Employee Name
Column C = Completion Date of Course
I have to report how many employees have completed each of the various Compliance courses YTD, and then how many have completed each course during just the 3rd Quarter.
Since the report was run as a YTD report, I used COUNTIF(Report!$A:$A,"Course Title"), just changing out the names of the various courses, to calculate the YTD numbers.
How do I nest in another function to count by course title and by date range? I need to know how many records there are for Course A completed between 7/1/2014 and 9/30/2014, then for Course B for the same date range, then Course C for the same date range, etc.
Thanks in advance for your time and assistance!
|