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

 | REP CODE | REP NAME | SUPERVISOR | DATE | SCHEDULED START TIME | ACTUAL LOGIN TIME | DEVIATION IN MINUTES | SCHEDULED EXCEPTIONS
[NAME] | [NAME] |  |  | 2009-09-14 00:00:00 | 08:00:00 | No Login | No Data
I8D | nm_I8D |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:03:18 | -11.70000000000007 |  |  | 59
I93 | nm_I93 |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data | OOA - Sick |  | 25
IAP | nm_IAP |  |  | 2009-09-14 00:00:00 | 13:15:00 | 16:01:53 | 166.8833333333333 | FMLA |  | 18
IAY | nm_IAY |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:17:34 | 2.566666666666535
ICT | nm_ICT |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:29:13 | 14.2166666666666
IGG | nm_IGG |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data |  |  | TARDIES | VALUE | PERCENTAGE
IL4 | nm_IL4 |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:15:33 | 0.5499999999999261 |  |  | TOTAL TARDIES | 55 | 1
ILD | nm_ILD |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data | OOA - Sick |  | TOTAL TARDIES > 5 MINUTES | 25 | 0.4545454545454545
IN4 | nm_IN4 |  |  | 2009-09-14 00:00:00 | 12:15:00 | No Login | No Data | OOA - Sick |  | TOTAL TARDIES > 10 MINUTES | 18 | 0.3272727272727273
IQI | nm_IQI |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data | OOA - Sick
IRH | nm_IRH |  |  | 2009-09-14 00:00:00 | 13:15:00 | 14:28:25 | 73.41666666666657 |  |  | SCHEDULED EXCEPTIONS
IRS | nm_IRS |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:19:05 | 4.083333333333385 |  |  | TOTAL EXCEPTIONS | 14
IVQ | nm_IVQ |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data |  |  | TOTAL EXCEPTIONS > 5 MINUTES | 11
I1Y | nm_I1Y |  |  | 2009-09-14 00:00:00 | 09:45:00 | No Login | No Data |  |  | TOTAL EXCEPTIONS > 10 MINUTES | 14
I75 | nm_I75 |  |  | 2009-09-14 00:00:00 | 10:15:00 | 09:31:11 | -43.81666666666659
I76 | nm_I76 |  |  | 2009-09-14 00:00:00 | 09:00:00 | 09:06:36 | 6.599999999999993
I88 | nm_I88 |  |  | 2009-09-14 00:00:00 | 09:00:00 | 09:08:07 | 8.116666666666683
I8B | nm_I8B |  |  | 2009-09-14 00:00:00 | 10:15:00 | 08:03:48 | -131.2
I8M | nm_I8M |  |  | 2009-09-14 00:00:00 | 10:15:00 | 10:19:22 | 4.366666666666736 |  |  | 55
IED | nm_IED |  |  | 2009-09-14 00:00:00 | 10:00:00 | No Login | No Data |  |  | 0
IF5 | nm_IF5 |  |  | 2009-09-14 00:00:00 | 10:15:00 | No Login | No Data |  |  | 18
IHD | [NAME] |  |  | 2009-09-14 00:00:00 | 10:15:00 | 10:08:23 | -6.616666666666688
IJ7 | nm_IJ7 |  |  | 2009-09-14 00:00:00 | 08:00:00 | No Login | No Data |  |  | 81
INQ | nm_INQ |  |  | 2009-09-14 00:00:00 | 08:45:00 | No Login | No Data
ITU | nm_ITU |  |  | 2009-09-14 00:00:00 | 09:00:00 | 08:57:16 | -2.733333333333334
IU9 | nm_IU9 |  |  | 2009-09-14 00:00:00 | 09:15:00 | No Login | No Data
IVX | nm_IVX |  |  | 2009-09-14 00:00:00 | 10:15:00 | 09:59:37 | -15.38333333333331
IW7 | nm_IW7 |  |  | 2009-09-14 00:00:00 | 08:00:00 | 09:00:26 | 60.43333333333332
IXX | nm_IXX |  |  | 2009-09-14 00:00:00 | 10:15:00 | 10:13:56 | -1.06666666666662
IZK | nm_IZK |  |  | 2009-09-14 00:00:00 | 09:30:00 | 09:50:53 | 20.88333333333338
I4Z | nm_I4Z |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:00:44 | 0.7333333333334213
I5R | nm_I5R |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:10:10 | 10.16666666666668
I5W | nm_I5W |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:14:39 | 14.65000000000005
I6I | nm_I6I |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:00:14 | 0.2333333333333432
I7K | [NAME] |  |  | 2009-09-14 00:00:00 | 07:15:00 | 07:03:02 | -11.96666666666665
I85 | nm_I85 |  |  | 2009-09-14 00:00:00 | 07:15:00 | 07:18:47 | 3.783333333333339
IF2 | nm_IF2 |  |  | 2009-09-14 00:00:00 | 07:00:00 | No Login | No Data | Personal Day
IF9 | nm_IF9 |  |  | 2009-09-14 00:00:00 | 07:00:00 | 06:56:08 | -3.866666666666658
IIA | nm_IIA |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:02:47 | 2.783333333333422
IKB | nm_IKB |  |  | 2009-09-14 00:00:00 | 07:00:00 | No Login | No Data
IL5 | nm_IL5 |  |  | 2009-09-14 00:00:00 | 07:00:00 | No Login | No Data
ILM | nm_ILM |  |  | 2009-09-14 00:00:00 | 07:15:00 | 07:11:46 | -3.233333333333253
IPH | nm_IPH |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:02:04 | 2.066666666666697
IUB | nm_IUB |  |  | 2009-09-14 00:00:00 | 07:15:00 | No Login | No Data | OOA - Sick
IVG | nm_IVG |  |  | 2009-09-14 00:00:00 | 07:00:00 | 06:53:59 | -6.016666666666595
IY3 | nm_IY3 |  |  | 2009-09-14 00:00:00 | 07:15:00 | 10:45:20 | 210.3333333333334
I21 | nm_I21 |  |  | 2009-09-14 00:00:00 | 12:15:00 | No Login | No Data
I2F | nm_I2F |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:19:10 | 4.166666666666625
I4W | nm_I4W |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data
I7Z | nm_I7Z |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data | OOA - Sick
IBQ | nm_IBQ |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:16:52 | 1.866666666666585
ICM | nm_ICM |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data
IDW | nm_IDW |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:12:25 | -2.583333333333471
IEA | nm_IEA |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data
IIF | nm_IIF |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:15:12 | 0.2000000000000313
IIT | nm_IIT |  |  | 2009-09-14 00:00:00 | 13:00:00 | 13:45:23 | 45.38333333333328
IN7 | nm_IN7 |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:15:49 | 0.8166666666665812
INI | nm_INI |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:11:37 | -3.383333333333436
IP2 | nm_IP2 |  |  | 2009-09-14 00:00:00 | 12:15:00 | 13:04:55 | 49.91666666666659 | OOA Late Start
IQ3 | nm_IQ3 |  |  | 2009-09-14 00:00:00 | 12:15:00 | No Login | No Data | Vacation
IQG | nm_IQG |  |  | 2009-09-14 00:00:00 | 13:15:00 | No Login | No Data | FMLA
IU6 | nm_IU6 |  |  | 2009-09-14 00:00:00 | 13:15:00 | 14:08:07 | 53.1166666666666
I31 | nm_I31 |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:11:01 | 11.01666666666674
I3X | nm_I3X |  |  | 2009-09-14 00:00:00 | 07:15:00 | 11:13:00 | 238
[NAME] | [NAME] |  |  | 2009-09-14 00:00:00 | 07:00:00 | No Login | No Data | OOA - Sick
I64 | nm_I64 |  |  | 2009-09-14 00:00:00 | 07:15:00 | 07:06:39 | -8.349999999999946
I8Y | nm_I8Y |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:15:23 | 15.38333333333339
I9G | nm_I9G |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:01:16 | 1.266666666666731
I9P | nm_I9P |  |  | 2009-09-14 00:00:00 | 07:00:00 | 06:58:15 | -1.749999999999954
ICR | nm_ICR |  |  | 2009-09-14 00:00:00 | 07:15:00 | 07:22:45 | 7.750000000000012
IDL | nm_IDL |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:00:09 | 0.1500000000001034
IEV | nm_IEV |  |  | 2009-09-14 00:00:00 | 07:15:00 | 07:18:15 | 3.250000000000028
IFP | nm_IFP |  |  | 2009-09-14 00:00:00 | 07:00:00 | No Login | No Data | OOA - Sick
IGB | [NAME] |  |  | 2009-09-14 00:00:00 | 07:15:00 | No Login | No Data
IH3 | nm_IH3 |  |  | 2009-09-14 00:00:00 | 07:00:00 | 06:59:30 | -0.4999999999999183
IJP | nm_IJP |  |  | 2009-09-14 00:00:00 | 07:00:00 | 06:59:56 | -0.0666666666666238
IQ9 | nm_IQ9 |  |  | 2009-09-14 00:00:00 | 07:15:00 | No Login | No Data
IR3 | nm_IR3 |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:00:00 | 0
ISD | nm_ISD |  |  | 2009-09-14 00:00:00 | 07:00:00 | 08:26:58 | 86.9666666666667
IXI | nm_IXI |  |  | 2009-09-14 00:00:00 | 07:15:00 | 07:14:09 | -0.849999999999973
I23 | nm_I23 |  |  | 2009-09-14 00:00:00 | 08:00:00 | 08:00:00 | 0
I2J | nm_I2J |  |  | 2009-09-14 00:00:00 | 08:30:00 | 07:32:36 | -57.39999999999994
I3V | nm_I3V |  |  | 2009-09-14 00:00:00 | 07:45:00 | 07:46:37 | 1.616666666666706
I59 | nm_I59 |  |  | 2009-09-14 00:00:00 | 07:00:00 | 08:30:05 | 90.08333333333331
I7P | nm_I7P |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:01:44 | 1.733333333333418
I8R | nm_I8R |  |  | 2009-09-14 00:00:00 | 08:30:00 | 08:30:04 | 0.06666666666670373
IB5 | nm_IB5 |  |  | 2009-09-14 00:00:00 | 07:30:00 | 07:00:00 | -30.00000000000005
IDG | nm_IDG |  |  | 2009-09-14 00:00:00 | 08:30:00 | 08:29:46 | -0.2333333333333432
IDZ | nm_IDZ |  |  | 2009-09-14 00:00:00 | 08:30:00 | 08:33:14 | 3.233333333333333
IFC | nm_IFC |  |  | 2009-09-14 00:00:00 | 08:30:00 | 08:10:14 | -19.76666666666659
IFD | nm_IFD |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:00:42 | 0.7000000000000295
ILR | nm_ILR |  |  | 2009-09-14 00:00:00 | 08:30:00 | 08:36:32 | 6.533333333333369
ISU | [NAME] |  |  | 2009-09-14 00:00:00 | 08:30:00 | 08:35:03 | 5.05000000000007
IT6 | nm_IT6 |  |  | 2009-09-14 00:00:00 | 07:15:00 | 08:53:32 | 98.53333333333327 | FMLA
ITW | nm_ITW |  |  | 2009-09-14 00:00:00 | 07:00:00 | 07:01:25 | 1.416666666666755
IYT | nm_IYT |  |  | 2009-09-14 00:00:00 | 08:00:00 | 08:04:20 | 4.333333333333425
I3S | nm_I3S |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:32:53 | 17.8833333333333
I96 | nm_I96 |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:15:00 | 0
IBH | nm_IBH |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:16:29 | 1.483333333333299
IFT | nm_IFT |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:16:56 | 1.933333333333209
IGT | [NAME] |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:22:33 | 7.549999999999901
II3 | nm_II3 |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:15:05 | 0.08333333333323978
IIK | nm_IIK |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:15:00 | 0
IQR | nm_IQR |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:19:38 | 4.633333333333312
IRL | nm_IRL |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:23:09 | 8.149999999999995
IRQ | nm_IRQ |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:15:56 | 0.9333333333333727
IS9 | nm_IS9 |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:19:48 | 4.799999999999951
ISX | nm_ISX |  |  | 2009-09-14 00:00:00 | 13:15:00 | 13:15:42 | 0.6999999999999496