Spreadsheet: 675863d1588527036-sumproduct-based-on-date-range-sheet-qry-column-c-based-on-qry-column-e-0-test-rhism-
Sheet: Qry

 | Name | Service_Date | Billing_Time | Billing_Rate
 | [NAME] | 2020-04-01 00:00:00 | 0.25 | 86.54
 | [NAME] | 2020-04-01 00:00:00 | 2.5 | 0
 | [NAME] | 2020-04-01 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-01 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-01 00:00:00 | 1.5 | 0
 | [NAME] | 2020-04-01 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-02 00:00:00 | 1 | 90
 | [NAME] | 2020-04-02 00:00:00 | 0.5 | 86.54
 | [NAME] | 2020-04-02 00:00:00 | 0.25 | 86.54
 | [NAME] | 2020-04-02 00:00:00 | 0.25 | 86.54
 | [NAME] | 2020-04-02 00:00:00 | 2.5 | 0
 | [NAME] | 2020-04-02 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-02 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-02 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-03 00:00:00 | 0.25 | 90
 | [NAME] | 2020-04-03 00:00:00 | 0.25 | 190
 | [NAME] | 2020-04-03 00:00:00 | 1 | 86.54
 | [NAME] | 2020-04-03 00:00:00 | 1 | 0
 | [NAME] | 2020-04-03 00:00:00 | 1 | 0
 | [NAME] | 2020-04-03 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-03 00:00:00 | 2.5 | 0
 | [NAME] | 2020-04-03 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-03 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-03 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-06 00:00:00 | 0.25 | 86.54
 | [NAME] | 2020-04-06 00:00:00 | 0.5 | 86.54
 | [NAME] | 2020-04-06 00:00:00 | 2.75 | 0
 | [NAME] | 2020-04-06 00:00:00 | 2 | 0
 | [NAME] | 2020-04-06 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-06 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-06 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-06 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-06 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-07 00:00:00 | 0.5 | 90
 | [NAME] | 2020-04-07 00:00:00 | 2.25 | 86.54
 | [NAME] | 2020-04-07 00:00:00 | 0.5 | 86.54
 | [NAME] | 2020-04-07 00:00:00 | 2 | 86.54
 | [NAME] | 2020-04-07 00:00:00 | 2 | 0
 | [NAME] | 2020-04-07 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-07 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-07 00:00:00 | 1.25 | 0
 | [NAME] | 2020-04-08 00:00:00 | 0.75 | 86.54
 | [NAME] | 2020-04-08 00:00:00 | 0.5 | 86.54
 | [NAME] | 2020-04-08 00:00:00 | 3.5 | 0
 | [NAME] | 2020-04-08 00:00:00 | 2.5 | 0
 | [NAME] | 2020-04-08 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-08 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-09 00:00:00 | 0.5 | 90
 | [NAME] | 2020-04-09 00:00:00 | 3.75 | 0
 | [NAME] | 2020-04-09 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-09 00:00:00 | 1 | 0
 | [NAME] | 2020-04-09 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-09 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-09 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-09 00:00:00 | 1 | 0
 | [NAME] | 2020-04-10 00:00:00 | 0.5 | 90
 | [NAME] | 2020-04-10 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-10 00:00:00 | 1.5 | 0
 | [NAME] | 2020-04-10 00:00:00 | 3.5 | 0
 | [NAME] | 2020-04-10 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-10 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-13 00:00:00 | 4.25 | 0
 | [NAME] | 2020-04-13 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-14 00:00:00 | 1 | 0
 | [NAME] | 2020-04-14 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-14 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-14 00:00:00 | 4 | 0
 | [NAME] | 2020-04-14 00:00:00 | 0.25 | 86.54
 | [NAME] | 2020-04-14 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-14 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-14 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-15 00:00:00 | 1 | 0
 | [NAME] | 2020-04-15 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-15 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-15 00:00:00 | 2.5 | 0
 | [NAME] | 2020-04-15 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-15 00:00:00 | 1.25 | 0
 | [NAME] | 2020-04-15 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-15 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-15 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-16 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-16 00:00:00 | 1.25 | 0
 | [NAME] | 2020-04-16 00:00:00 | 1.5 | 0
 | [NAME] | 2020-04-16 00:00:00 | 1.5 | 0
 | [NAME] | 2020-04-16 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-16 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-16 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-16 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-16 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-17 00:00:00 | 0.25 | 190
 | [NAME] | 2020-04-17 00:00:00 | 1 | 86.54
 | [NAME] | 2020-04-17 00:00:00 | 0.75 | 86.54
 | [NAME] | 2020-04-17 00:00:00 | 1.75 | 0
 | [NAME] | 2020-04-17 00:00:00 | 2.25 | 0
 | [NAME] | 2020-04-17 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-17 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-17 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-17 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-17 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-20 00:00:00 | 1.25 | 0
 | [NAME] | 2020-04-20 00:00:00 | 1 | 0
 | [NAME] | 2020-04-20 00:00:00 | 1.75 | 0
 | [NAME] | 2020-04-20 00:00:00 | 1 | 0
 | [NAME] | 2020-04-20 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-20 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-20 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-20 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-21 00:00:00 | 0.25 | 90
 | [NAME] | 2020-04-21 00:00:00 | 1 | 86.54
 | [NAME] | 2020-04-21 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-21 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-21 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-21 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-21 00:00:00 | 2 | 0
 | [NAME] | 2020-04-21 00:00:00 | 1 | 86.54
 | [NAME] | 2020-04-21 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-21 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-21 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-21 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-21 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-22 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-22 00:00:00 | 1 | 0
 | [NAME] | 2020-04-22 00:00:00 | 1 | 0
 | [NAME] | 2020-04-22 00:00:00 | 2 | 0
 | [NAME] | 2020-04-22 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-22 00:00:00 | 1.5 | 0
 | [NAME] | 2020-04-22 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-23 00:00:00 | 0.25 | 90
 | [NAME] | 2020-04-23 00:00:00 | 0.25 | 86.54
 | [NAME] | 2020-04-23 00:00:00 | 1.5 | 0
 | [NAME] | 2020-04-23 00:00:00 | 1.25 | 0
 | [NAME] | 2020-04-23 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-23 00:00:00 | 1.75 | 0
 | [NAME] | 2020-04-23 00:00:00 | 1 | 0
 | [NAME] | 2020-04-23 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-23 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-24 00:00:00 | 0.75 | 86.54
 | [NAME] | 2020-04-24 00:00:00 | 2 | 0
 | [NAME] | 2020-04-24 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-24 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-24 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-24 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-24 00:00:00 | 1 | 0
 | [NAME] | 2020-04-24 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-24 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-24 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-27 00:00:00 | 1.5 | 86.54
 | [NAME] | 2020-04-27 00:00:00 | 1.5 | 86.54
 | [NAME] | 2020-04-27 00:00:00 | 0.75 | 0
 | [NAME] | 2020-04-27 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-27 00:00:00 | 1 | 0
 | [NAME] | 2020-04-27 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-27 00:00:00 | 1.25 | 0
 | [NAME] | 2020-04-28 00:00:00 | 1 | 90
 | [NAME] | 2020-04-28 00:00:00 | 0.5 | 86.54
 | [NAME] | 2020-04-28 00:00:00 | 1 | 0
 | [NAME] | 2020-04-28 00:00:00 | 1 | 0
 | [NAME] | 2020-04-29 00:00:00 | 0.5 | 86.54
 | [NAME] | 2020-04-29 00:00:00 | 0.25 | 86.54
 | [NAME] | 2020-04-29 00:00:00 | 2 | 86.54
 | [NAME] | 2020-04-29 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-29 00:00:00 | 1.5 | 0
 | [NAME] | 2020-04-29 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-29 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-30 00:00:00 | 2 | 0
 | [NAME] | 2020-04-30 00:00:00 | 1 | 0
 | [NAME] | 2020-04-30 00:00:00 | 1 | 0
 | [NAME] | 2020-04-30 00:00:00 | 1.5 | 0
 | [NAME] | 2020-04-30 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-30 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-30 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-30 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-30 00:00:00 | 0.25 | 0
 | [NAME] | 2020-04-30 00:00:00 | 0.5 | 0
 | [NAME] | 2020-04-30 00:00:00 | 0.5 | 0