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),"")))
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),"")))
Facilitator | Module | Modules Trained | Module Hours | Certified Y/N |
Pierce, Andrew | Cambium | 3 | 4.5 | Y |
VoIP | 5 | 10 | Y | |
Adv Tools | 5 | 10 | Y | |
Billing | 2 | 3.5 | ||
Upgrades | 6 | 12 | Y | |
LTE | 0 | 0 | ||
Ubiquiti | 0 | 0 | ||
Adv Tools 2 | 0 | 0 | ||
Agent | Date | Module | Hours | L2 AST | L3 AST | Pass Y/N | Facilitator | Facilitator Hours |
Erickson, Jason | 4/11/22 | Adv Tools | 2 | y | TBA | 2.5 | ||
Sparks, Dianne | 4/12/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Sherwood, Donald | 4/12/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Wiitala, Jonathan | 4/12/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Figueroa, Jaelyn | 4/12/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Schade, Lynda | 4/12/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Chesnick, Kyle | 4/12/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Frank, Christopher | 4/12/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Baker, Joseph | 4/12/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Cantrell, Charles | 4/12/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Delon, Anthony | 4/12/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Sott, Erin | 4/13/22 | Adv Tools | 0 | n | Rattarre, Logan | 2.5 | ||
Davila, Mercedes | 4/13/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Kachel, Gregg S | 4/13/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Myers, Leslie J | 4/13/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Weller, Julia | 4/13/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Parsons, Christian | 4/13/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Wardin, Derek | 4/13/22 | Adv Tools | 2 | y | Rattarre, Logan | 2.5 | ||
Welborn, Ashley | 4/13/22 | Adv Tools | 2 | y | Rattarre, Logan | 2.5 | ||
Christensen, Nicholas | 4/13/22 | Adv Tools | 2 | y | Rattarre, Logan | 2.5 | ||
Derringer, Ryan | 4/13/22 | Adv Tools | 2 | y | Rattarre, Logan | 2.5 | ||
MacLean, Thomas | 4/13/22 | Adv Tools | 2 | y | Rattarre, Logan | 2.5 | ||
Dunn, Cody | 4/13/22 | Adv Tools | 2 | y | Rattarre, Logan | 2.5 | ||
Ornelas, Cathline | 4/13/22 | Adv Tools | 2 | y | Rattarre, Logan | 2.5 | ||
Cano, Arthur | 4/14/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Gertge, Josiah | 4/14/22 | Adv Tools | 2 | Y | Pierce, Andrew | 2.5 | ||
Casanova, Erica V | 4/14/22 | Adv Tools | 2 | Y | Pierce, Andrew | 2.5 | ||
Lennemann, Kerry | 4/14/22 | Adv Tools | 2 | Y | Pierce, Andrew | 2.5 | ||
Brakke, Bryson | 4/14/22 | Adv Tools | 2 | Y | Pierce, Andrew | 2.5 | ||
Roybal, Andres | 4/14/22 | Adv Tools | 2 | Y | Pierce, Andrew | 2.5 | ||
Bowes, Alexandra | 4/14/22 | Adv Tools | 2 | Y | Pierce, Andrew | 2.5 | ||
Perez, Dominic | 4/14/22 | Adv Tools | 2 | Y | Pierce, Andrew | 2.5 | ||
Pena, Jacob | 4/14/22 | Adv Tools | 2 | Y | Pierce, Andrew | 2.5 | ||
Miller, Seth Tyler James | 4/26/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Briceno, Austin L | 4/15/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Madigan, Aidan R | 4/15/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Crowley, Evan | 4/15/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Shadid, James | 4/15/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
DuBard, Chase | 4/15/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Harding, Jacob | 4/15/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Baird, David | 4/15/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Holford, Charles | 4/15/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Skees, Matthew | 4/26/22 | Adv Tools | 2 | y | Pierce, Andrew | 2.5 | ||
Kunz, Maria | 4/16/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Escobar, Samuel Charles | 4/16/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Romano, Scott | 4/16/22 | Adv Tools | 2 | Y | Rattarre, Logan | 2.5 | ||
Briceno, Austin L | 4/16/22 | Billing | 0 | n | Pierce, Andrew | 2.25 | ||
Chesnick, Kyle | 4/16/22 | Billing | 2 | Y | Rattarre, Logan | 2.25 | ||
Bowes, Alexandra | 4/16/22 | Billing | 2 | Y | Rattarre, Logan | 2.25 | ||
Crowley, Evan | 4/16/22 | Billing | 2 | Y | Rattarre, Logan | 2.25 | ||
Frank, Christopher | 4/16/22 | Billing | 2 | Y | Rattarre, Logan | 2.25 | ||