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!

Hi
perhaps post a sample sheet. A Pivot Table might do the job

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks, it probably would work, and Pivot Tables are one area I admit almost complete ignorance on!

I kept digging for an answer after I posted, and was able to use COUNTIFS to get what I needed.

So to count the number of employees who took Course A in the 3rd Quarter (July 1-Sept 30), I ended up with the following formula:

=COUNTIFS(Report!A:A,"Course A",Report!C:C,">=7/1/2014",Report!C:C,"<=9/30/2014")

There most likely is an easier or cleaner way...and I really need to learn how to use Pivot Tables!

Yes, a pivot table would be much easier and allows for automated grouping by various date bins including quarter. If you post a sample sheet, one of us can buff one up for you.