Spreadsheet: 675559d1588353545-sumproduct-based-on-date-range-sheet-qry-column-c-based-on-qry-column-e-0-test
Sheet: Qry

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