|
|
|
|
#1
10-17-2014, 12:01 PM
|
|||
|
|||
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! 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Restrict Date Range Calculations
|
akatz85 | Excel | 4 | 03-27-2014 08:46 PM |
| Date range mysteriously adding 4 years | akatz85 | Excel | 7 | 03-25-2014 12:36 PM |
|
How to count even exact date 90 days
|
redza | Excel | 1 | 09-17-2013 03:36 AM |
| Make table cell active add date count date | MelHerndon | Word VBA | 3 | 01-21-2013 04:23 PM |
|
Date Range Prompt
|
MikeWooZ | Excel | 6 | 12-04-2011 02:10 PM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode