Spreadsheet: 790086d1659533088-countifs-with-multiple-criteria-formula-mock-up
Sheet: Balancing - RN

AM | MONSTER FORMULA
 | FAULTY REPLACEMENT
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | 2022-07-10 00:00:00 | 2022-07-11 00:00:00 | 2022-07-12 00:00:00 | 2022-07-13 00:00:00 | 2022-07-14 00:00:00 | 2022-07-15 00:00:00 | 2022-07-16 00:00:00
Employee | Employee2 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
CNS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CNS | [NAME], Emily | 0 | 0 | 0 | 0 | 0 | 0 | 0
CNS | Barsola-Canaveral, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
CNS | Battles, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
CNS | Blackey, [NAME] | 0 | 0700-12 | 0 | 0 | 0 | 0 | 0
CNS | [NAME], [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 1900-12
CNS | Dustin, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
CNS | LaMorticelli, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
CNS | Limanek, [NAME] | 0 | 0 | 0700-12 | 0 | 0 | 0 | 0
CNS | Mercer, Shannon | 0 | 0 | 0 | 0 | 1900-12 | 0 | 0
CNS | Sefakis, Bethany | 0 | 0 | 0 | 0 | 0 | 0 | 0
CNS | [NAME], Bess | 0 | 0 | 0 | 0 | 0 | 0 | 0
CNS | Westenfeld, Callie | 0700-12 | 0 | 0 | 0 | 0700-12 | 0 | 0700-12
CNS | Wider, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | Adams, Jennifer | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | [NAME], Christie | 0 | 0700-12 | 1900-12 | 0 | 0 | 0 | 0700-12
RN | [NAME], Emily | 0700-12 | 0700-12 | 1900-12 | 0 | Con Inc 1900-12 | 0 | 0
RN | Appleton, [NAME] | 0 | 0 | 0 | 0700-12 | 0 | 0700-12 | 0700-12
RN | Barrie, [NAME] | 0 | 0 | 0 | 0 | 0 | 1900-12 | 0
RN | Barsola-Canaveral, [NAME] | 0 | 1900-12 | 1900-12 | 0 | 0 | 0 | 0
RN | Battles, [NAME] | 1900-12 | 1900-12 | 0 | 0 | 0 | 0 | 1900-12
RN | Billings, Victoria | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | Blackerby, Mary | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | Blackey, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | Bresnahan, [NAME] | 0 | 0 | 0700-12 | 0700-12 | 0 | 0 | 0700-12
RN | Cagas, Wynn | 0700-12 | 0700-12 | 0 | 0 | 0700-12 | 0700-12 | 0
RN | Campos, Bianca | 0700-12 | 0 | 0700-12 | 0 | 0700-12 | 0 | 0
RN | Carr, Emily | 0700-12 | 0700-12 | 0 | 0 | 0 | 0700-12 | 0
RN | Chito, Brittany | 0700-12 | 0 | 0700-12 | 0700-12 | 0 | 0 | 0
RN | Cole, Dustin | 0700-12 | 0700-12 | X0700-12 | 0 | X0700-12 | 0700-12 | 0
RN | Cyrs, Samantha | 0 | 0 | 0 | 0 | 0700-12 | 1900-12 | 1900-12
RN | [NAME], [NAME] | 1900-12 | 0 | 0 | 0 | 0 | 1900-12 | 0
RN | Dumont, [NAME] | 1900-12 | 1900-12 | 0 | 1900-12 | 0 | 0 | 0
RN | Dustin, [NAME] | 0 | Con Inc 1900-12 | 1900-12 | 0 | 0 | 1900-12 | 1900-12
RN | [NAME], Shawna | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | Gilman, [NAME] | 0 | 0 | Con Inc 1900-12 | 0 | 0 | 0 | 0
RN | Govindaswamy, Loganathan | 0 | 0 | 0 | 0 | 0 | 1900-12 | 1900-12
RN | [NAME], [NAME] | 0 | 1900-12 | 0 | 1900-12 | 1900-12 | 0 | 0
RN | Kaufman, [NAME] | 0 | 0 | 0 | 0700-12 | 0 | 0 | 0
RN | [NAME], [NAME] | 0 | 0 | 0 | 0700-12 | 0 | 0 | 0
RN | Laffin, [NAME] | 0700-12 | 0700-12 | 0 | 0 | 0700-12 | 0 | 0
RN | LaMorticelli, [NAME] | 0 | 0 | 0 | 0 | 0 | 0700-12 | 0700-12
RN | Landry, Anissa | Con Inc 1900-12 | 0 | 0700-12 | 0700-12 | 0 | 0 | 0700-12
RN | [NAME], [NAME] | 0 | 0 | 1900-12 | 1900-12 | 1900-12 | 0 | 0
RN | Limanek, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0700-12
RN | MacDonald, Kylee | 0 | 0 | 0 | 0 | 1900-12 | 1900-12 | 1900-12
RN | [NAME], [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | [NAME], [NAME] | 0 | 0 | 0 | 0 | 0700-12 | 0700-12 | 0700-12
RN | [NAME], [NAME] | 1900-12 | 1900-12 | 0 | 1900-12 | 0 | 0 | 0
RN | [NAME], [NAME] | 0 | 0700-12 | 0700-12 | 0700-12 | 0 | 0 | 0
RN | [NAME], [NAME] | 0 | 0 | ¤O0700-12 | 0 | ¤O0700-12 | 0700-12 | 0
RN | Perez, Mariel | 1900-12 | 1900-12 | 0 | 1900-12 | 0 | 0 | 0
RN | Putnam, [NAME] | 0 | 0 | 0 | 0 | 0 | 1900-12 | 1900-12
RN | [NAME], [NAME] | 0 | 0 | 1900-12 | 1900-12 | 1900-12 | 0 | 0
RN | Reilly, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | Schulz, [NAME] | 0 | 0 | 0 | 0700-12 | 0700-12 | 1900-12 | 0
RN | Shewmaker, [NAME] | 0 | 0 | 0 | 0700-12 | 0 | 0700-12 | 0700-12
RN | Smyrock, [NAME] | 1900-12 | 0 | 1900-12 | 1900-12 | 0 | 0 | 0
RN | [NAME], Pauleena | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | Sun, [NAME] | 0 | 0 | 0700-12 | 0700-12 | 0700-12 | 0 | 0
RN | [NAME], Bess | 0 | 0 | 0 | 0 | 0 | 0 | 0
RN | Walsh, [NAME] | 0 | 1100-12 | 0 | 0 | 0 | 0 | 0
LPN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LPN | Pickell, Carissa | 0900-12 | 0900-12 | 0 | 0 | 0900-12 | 0 | 0
LPN | Towne, Holly | 0 | 0 | 0 | 0 | 0 | 0 | 0
PCU - CNS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PCU - CNS | Mercer, Shannon | 0 | 1900-12 | 0 | 0 | 0 | 1900-12 | 0
PCU - CNS | Sefakis, Bethany | 0 | 0 | 0 | 0 | 0 | 0700-12 | 0
PCU - CNS | [NAME], Bess | 0 | 0 | 0 | 0700-12 | 0 | 0 | 0
PCU - CNS | Westenfeld, Callie | 0 | 0 | 0 | 0 | 0 | 0 | 0
PCU - CNS | Wider, [NAME] | 1900-12 | 0 | 1900-12 | 1900-12 | 0 | 0 | 0
4 PCU | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 PCU | Adams, Jennifer | 0 | 0700-12 | 0700-12 | 0 | 0 | 0 | 0
4 PCU | Barrie, [NAME] | 0 | 0 | 0 | 0 | 1900-12 | 0 | 1900-12
4 PCU | Blackerby, Mary | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 PCU | Blackey, [NAME] | 0 | 0 | 7ASafeC | 0 | 0 | 0 | 0
4 PCU | [NAME], Shawna | 1900-12 | 1900-12 | 0 | 1900-12 | 0 | 0 | 0
4 PCU | Gilman, [NAME] | 0 | 0 | 0 | 0 | 1900-12 | 1900-12 | 1900-12
4 PCU | [NAME], [NAME] | 0 | 0 | 0700-12 | 0700-12 | 0 | 0 | 0700-12
4 PCU | Limanek, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 PCU | [NAME], [NAME] | 0 | 0700-12 | 0 | 0 | 0700-12 | 0700-12 | 0
4 PCU | Putnam, [NAME] | 0 | 0 | 1900-12 | 0 | 0 | 0 | 0
4 PCU | Sefakis, Bethany | 0700-12 | 0 | 0 | 0 | 0 | 0 | 0700-12
4 PCU | Thompson, Rebecca | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 PCU | [NAME], Bess | 0700-12 | 0 | 0 | 0 | 0700-12 | 0 | 0