![]() |
|
|
|
#1
|
||||
|
||||
|
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 |
|
#2
|
|||
|
|||
|
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 |