Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2014, 11:53 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Count how many have completed each Training Course within a Date Range Windows 7 64bit Count how many have completed each Training Course within a Date Range Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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
Reply With Quote
  #2  
Old 10-17-2014, 12:01 PM
dmcmillion dmcmillion is offline Count how many have completed each Training Course within a Date Range Windows 7 32bit Count how many have completed each Training Course within a Date Range Office 2010 32bit
Novice
Count how many have completed each Training Course within a Date Range
 
Join Date: Oct 2014
Posts: 2
dmcmillion is on a distinguished road
Default

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!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Count how many have completed each Training Course within a Date Range 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
Count how many have completed each Training Course within a Date Range 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
Count how many have completed each Training Course within a Date Range Date Range Prompt MikeWooZ Excel 6 12-04-2011 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft