Calculating training classes by number of classes, trainer and date

kxellis26

New Member
Joined
Mar 11, 2022
Messages
31
Office Version
  1. 365
Platform
  1. Windows
Greetings -

I am working on a sheet that I built to track training classes. I currently have it set up to sum the total amount of classes completed for each course. However, I am looking to go even further and add in date range. For instance, in the table below, I currently have the number of classes by each trainer for the year. I need to break this out by each month.

I realize it will take more space, but right now I am just looking to include date range in this formula -

=COUNT(UNIQUE(FILTER('Training Log'!C:C,('Training Log'!I:I='Facilitator Roll-Up'!B$3)*('Training Log'!D:D='Facilitator Roll-Up'!C13),"")))

FacilitatorModuleModules TrainedModule HoursCertified Y/N
Pierce, AndrewCambium34.5Y
VoIP510Y
Adv Tools510Y
Billing23.5
Upgrades612Y
LTE00
Ubiquiti00
Adv Tools 200


AgentDateModuleHoursL2 ASTL3 ASTPass Y/NFacilitatorFacilitator Hours
Erickson, Jason4/11/22Adv Tools2yTBA2.5
Sparks, Dianne4/12/22Adv Tools2yPierce, Andrew2.5
Sherwood, Donald4/12/22Adv Tools2yPierce, Andrew2.5
Wiitala, Jonathan4/12/22Adv Tools2yPierce, Andrew2.5
Figueroa, Jaelyn4/12/22Adv Tools2yPierce, Andrew2.5
Schade, Lynda4/12/22Adv Tools2yPierce, Andrew2.5
Chesnick, Kyle4/12/22Adv Tools2YRattarre, Logan2.5
Frank, Christopher4/12/22Adv Tools2YRattarre, Logan2.5
Baker, Joseph4/12/22Adv Tools2YRattarre, Logan2.5
Cantrell, Charles4/12/22Adv Tools2YRattarre, Logan2.5
Delon, Anthony4/12/22Adv Tools2YRattarre, Logan2.5
Sott, Erin4/13/22Adv Tools0nRattarre, Logan2.5
Davila, Mercedes4/13/22Adv Tools2yPierce, Andrew2.5
Kachel, Gregg S4/13/22Adv Tools2yPierce, Andrew2.5
Myers, Leslie J4/13/22Adv Tools2yPierce, Andrew2.5
Weller, Julia4/13/22Adv Tools2yPierce, Andrew2.5
Parsons, Christian4/13/22Adv Tools2yPierce, Andrew2.5
Wardin, Derek4/13/22Adv Tools2yRattarre, Logan2.5
Welborn, Ashley4/13/22Adv Tools2yRattarre, Logan2.5
Christensen, Nicholas4/13/22Adv Tools2yRattarre, Logan2.5
Derringer, Ryan4/13/22Adv Tools2yRattarre, Logan2.5
MacLean, Thomas4/13/22Adv Tools2yRattarre, Logan2.5
Dunn, Cody4/13/22Adv Tools2yRattarre, Logan2.5
Ornelas, Cathline4/13/22Adv Tools2yRattarre, Logan2.5
Cano, Arthur4/14/22Adv Tools2YRattarre, Logan2.5
Gertge, Josiah4/14/22Adv Tools2YPierce, Andrew2.5
Casanova, Erica V4/14/22Adv Tools2YPierce, Andrew2.5
Lennemann, Kerry4/14/22Adv Tools2YPierce, Andrew2.5
Brakke, Bryson4/14/22Adv Tools2YPierce, Andrew2.5
Roybal, Andres4/14/22Adv Tools2YPierce, Andrew2.5
Bowes, Alexandra4/14/22Adv Tools2YPierce, Andrew2.5
Perez, Dominic4/14/22Adv Tools2YPierce, Andrew2.5
Pena, Jacob4/14/22Adv Tools2YPierce, Andrew2.5
Miller, Seth Tyler James4/26/22Adv Tools2yPierce, Andrew2.5
Briceno, Austin L4/15/22Adv Tools2YRattarre, Logan2.5
Madigan, Aidan R4/15/22Adv Tools2YRattarre, Logan2.5
Crowley, Evan4/15/22Adv Tools2YRattarre, Logan2.5
Shadid, James4/15/22Adv Tools2YRattarre, Logan2.5
DuBard, Chase4/15/22Adv Tools2YRattarre, Logan2.5
Harding, Jacob4/15/22Adv Tools2YRattarre, Logan2.5
Baird, David4/15/22Adv Tools2YRattarre, Logan2.5
Holford, Charles4/15/22Adv Tools2YRattarre, Logan2.5
Skees, Matthew4/26/22Adv Tools2yPierce, Andrew2.5
Kunz, Maria4/16/22Adv Tools2YRattarre, Logan2.5
Escobar, Samuel Charles4/16/22Adv Tools2YRattarre, Logan2.5
Romano, Scott4/16/22Adv Tools2YRattarre, Logan2.5
Briceno, Austin L4/16/22Billing0nPierce, Andrew2.25
Chesnick, Kyle4/16/22Billing2YRattarre, Logan2.25
Bowes, Alexandra4/16/22Billing2YRattarre, Logan2.25
Crowley, Evan4/16/22Billing2YRattarre, Logan2.25
Frank, Christopher4/16/22Billing2YRattarre, Logan2.25
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,216,128
Messages
6,129,036
Members
449,482
Latest member
al mugheen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top