Spreadsheet: 54464d1254438988-i-need-multiple-criteria-met-in-a-sumproduct-formula-please-help-sample_workbook
Sheet: SCHED_START

MONDAY
I8M | nm_I8M | [NAME], [NAME] | 09/14/2009 11:15 AM | 11:15:00 | 2009-09-14 00:00:00 | 10:15:00
I3S | nm_I3S | [NAME], [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IT6 | nm_IT6 | Appelhans, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
I3V | nm_I3V | Barraza, [NAME] | 09/14/2009 08:45 AM | 08:45:00 | 2009-09-14 00:00:00 | 07:45:00
I96 | nm_I96 | Bastow, Blain | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I21 | nm_I21 | Beeler, [NAME] | 09/14/2009 01:15 PM | 13:15:00 | 2009-09-14 00:00:00 | 12:15:00
IAY | nm_IAY | Bendon, Amanda | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IXI | nm_IXI | Bonifant, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
I8D | nm_I8D | Borlovan, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IY3 | nm_IY3 | Brougham, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
IBH | nm_IBH | [NAME], [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IU9 | nm_IU9 | Cann, [NAME] | 09/14/2009 10:15 AM | 10:15:00 | 2009-09-14 00:00:00 | 09:15:00
IPH | nm_IPH | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
[NAME] | [NAME] | Casias, [NAME] | 09/14/2009 09:00 AM | 09:00:00 | 2009-09-14 00:00:00 | 08:00:00
I9P | nm_I9P | Cavalier, [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IU6 | nm_IU6 | [NAME], Aleric | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I75 | nm_I75 | Cooper, [NAME] | 09/14/2009 11:15 AM | 11:15:00 | 2009-09-14 00:00:00 | 10:15:00
[NAME] | [NAME] | Covo, [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
I5R | nm_I5R | Cruz, [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IUB | nm_IUB | Davenport, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
I23 | nm_I23 | Despres, Maile | 09/14/2009 09:00 AM | 09:00:00 | 2009-09-14 00:00:00 | 08:00:00
IFT | nm_IFT | Diem, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I2F | nm_I2F | Dombrowsky, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I1Y | nm_I1Y | [NAME], [NAME] | 09/14/2009 10:45 AM | 10:45:00 | 2009-09-14 00:00:00 | 09:45:00
I9G | nm_I9G | Dotson, [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
I8Y | nm_I8Y | Doyle, [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IQ9 | nm_IQ9 | Durham, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
I93 | nm_I93 | Edison, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IQI | nm_IQI | [NAME], [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I88 | nm_I88 | Flores, [NAME] | 09/14/2009 10:00 AM | 10:00:00 | 2009-09-14 00:00:00 | 09:00:00
IDW | nm_IDW | Flores, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IJ7 | nm_IJ7 | [NAME], [NAME] | 09/14/2009 09:00 AM | 09:00:00 | 2009-09-14 00:00:00 | 08:00:00
II3 | nm_II3 | [NAME], [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IFC | nm_IFC | [NAME], [NAME] | 09/14/2009 09:30 AM | 09:30:00 | 2009-09-14 00:00:00 | 08:30:00
IFP | nm_IFP | Gertz, [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IAP | nm_IAP | Gloeckler, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IBQ | nm_IBQ | Gonzales, David | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I2J | nm_I2J | Gonzales, Gary | 09/14/2009 09:30 AM | 09:30:00 | 2009-09-14 00:00:00 | 08:30:00
I31 | nm_I31 | Goshai, Eva | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IGT | [NAME] | Gowdy-Robinson, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IIK | nm_IIK | Grogan, Crystal | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IF5 | nm_IF5 | [NAME], [NAME] | 09/14/2009 11:15 AM | 11:15:00 | 2009-09-14 00:00:00 | 10:15:00
ITW | nm_ITW | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IEA | nm_IEA | Hallonquist, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IVX | nm_IVX | [NAME], [NAME] | 09/14/2009 11:15 AM | 11:15:00 | 2009-09-14 00:00:00 | 10:15:00
I76 | nm_I76 | Harsch, [NAME] | 09/14/2009 10:00 AM | 10:00:00 | 2009-09-14 00:00:00 | 09:00:00
I59 | nm_I59 | Herrera, Yolanda | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IQG | nm_IQG | Hill, Minnie | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IHD | [NAME] | Hinojosa, [NAME] | 09/14/2009 11:15 AM | 11:15:00 | 2009-09-14 00:00:00 | 10:15:00
I8R | nm_I8R | Houghland, Dale | 09/14/2009 09:30 AM | 09:30:00 | 2009-09-14 00:00:00 | 08:30:00
IGG | nm_IGG | Hyde, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
INQ | nm_INQ | Irish, Dennis | 09/14/2009 09:45 AM | 09:45:00 | 2009-09-14 00:00:00 | 08:45:00
ILR | nm_ILR | Jones, [NAME] | 09/14/2009 09:30 AM | 09:30:00 | 2009-09-14 00:00:00 | 08:30:00
ILD | nm_ILD | Larralde, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IN7 | nm_IN7 | Litchenberger, Stacy | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IKB | nm_IKB | Lucas, Amanda | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
ISD | nm_ISD | Malik, Sajidah | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IRH | nm_IRH | Malone, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IDG | nm_IDG | [NAME], [NAME] | 09/14/2009 09:30 AM | 09:30:00 | 2009-09-14 00:00:00 | 08:30:00
ICT | nm_ICT | Martin, Emile | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
ILM | nm_ILM | Mayse, Madeline | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
I6I | nm_I6I | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IYT | nm_IYT | McHutchion, [NAME] | 09/14/2009 09:00 AM | 09:00:00 | 2009-09-14 00:00:00 | 08:00:00
IL5 | nm_IL5 | [NAME], Kristina | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
I3X | nm_I3X | [NAME], [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
IGB | [NAME] | Mendiola, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
IRS | nm_IRS | [NAME], Heather | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IQR | nm_IQR | Moore, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
ISU | [NAME] | Moore, [NAME] | 09/14/2009 09:30 AM | 09:30:00 | 2009-09-14 00:00:00 | 08:30:00
IDL | nm_IDL | Moralez, Teresa | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IED | nm_IED | [NAME], Darrin | 09/14/2009 11:00 AM | 11:00:00 | 2009-09-14 00:00:00 | 10:00:00
IRL | nm_IRL | Odewumi, Adam | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I85 | nm_I85 | Olivo, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
IB5 | nm_IB5 | Palomo, [NAME] | 09/14/2009 08:30 AM | 08:30:00 | 2009-09-14 00:00:00 | 07:30:00
IRQ | nm_IRQ | Paraoan, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I8B | nm_I8B | [NAME], Freddie | 09/14/2009 11:15 AM | 11:15:00 | 2009-09-14 00:00:00 | 10:15:00
ICR | nm_ICR | Pena, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
IEV | nm_IEV | Perez, Alfred | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
I5W | nm_I5W | Richardson, Kimberly | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
I7Z | nm_I7Z | Rigsby, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IW7 | nm_IW7 | [NAME], [NAME] | 09/14/2009 09:00 AM | 09:00:00 | 2009-09-14 00:00:00 | 08:00:00
IIF | nm_IIF | [NAME], [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IF2 | nm_IF2 | Rodriguez, Juan | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IVG | nm_IVG | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IIT | nm_IIT | Roesch, Lance | 09/14/2009 02:00 PM | 14:00:00 | 2009-09-14 00:00:00 | 13:00:00
IFD | nm_IFD | Rosales, Javier | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IS9 | nm_IS9 | Rosenbaum, Stephanie | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I7K | [NAME] | Sierra, [NAME] | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
ISX | nm_ISX | Singh, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IL4 | nm_IL4 | Solomon, Rossie | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
ITU | nm_ITU | [NAME], [NAME] | 09/14/2009 10:00 AM | 10:00:00 | 2009-09-14 00:00:00 | 09:00:00
IQ3 | nm_IQ3 | [NAME], [NAME] | 09/14/2009 01:15 PM | 13:15:00 | 2009-09-14 00:00:00 | 12:15:00
I7P | nm_I7P | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IDZ | nm_IDZ | Tompkins, Nathan | 09/14/2009 09:30 AM | 09:30:00 | 2009-09-14 00:00:00 | 08:30:00
IVQ | nm_IVQ | Trimble, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IXX | nm_IXX | Tyler, [NAME] | 09/14/2009 11:15 AM | 11:15:00 | 2009-09-14 00:00:00 | 10:15:00
ICM | nm_ICM | Villalta, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IP2 | nm_IP2 | Villarreal, [NAME] | 09/14/2009 01:15 PM | 13:15:00 | 2009-09-14 00:00:00 | 12:15:00
I64 | nm_I64 | West, Ladis | 09/14/2009 08:15 AM | 08:15:00 | 2009-09-14 00:00:00 | 07:15:00
IR3 | nm_IR3 | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IIA | nm_IIA | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IZK | nm_IZK | [NAME], [NAME] | 09/14/2009 10:30 AM | 10:30:00 | 2009-09-14 00:00:00 | 09:30:00
I4Z | nm_I4Z | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IF9 | nm_IF9 | [NAME], [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
IH3 | nm_IH3 | Woodruff, Sidney | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00
INI | nm_INI | [NAME], [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
I4W | nm_I4W | Woolard, [NAME] | 09/14/2009 02:15 PM | 14:15:00 | 2009-09-14 00:00:00 | 13:15:00
IN4 | nm_IN4 | Wooldridge, [NAME] | 09/14/2009 01:15 PM | 13:15:00 | 2009-09-14 00:00:00 | 12:15:00
IJP | nm_IJP | Yankay, [NAME] | 09/14/2009 08:00 AM | 08:00:00 | 2009-09-14 00:00:00 | 07:00:00