Spreadsheet: 752452d1634759659-sumproduct-multiplying-based-on-multiple-conditions-hop_inv_tracking_example
Sheet: Calendar

 |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
Week # | Date | Brand | Dry Hopping | Brand | Dry Hopping | Brand | Dry Hopping | Brand | Dry Hopping | Brand | Dry Hopping | Brand | Dry Hopping
Week 23 | 2021-06-06 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-07 00:00:00 | Beer 1 | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-08 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-09 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-10 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-11 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-12 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 24 | 2021-06-13 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-14 00:00:00 | Beer 3 | DH (10bbls) | - | - | - | - | - | - | - | - | - | -
 | 2021-06-15 00:00:00 | Beer 2 | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-16 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-17 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-18 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-19 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 25 | 2021-06-20 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-21 00:00:00 | Beer 1 | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-22 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-23 00:00:00 | Beer 3 | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-24 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-25 00:00:00 | Beer 4 | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-26 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 26 | 2021-06-27 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-28 00:00:00 | Beer 1 | DH (20bbls) | - | - | - | - | - | - | - | - | - | -
 | 2021-06-29 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-06-30 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-01 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-02 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-03 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 27 | 2021-07-04 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-05 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-06 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-07 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-08 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-09 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-10 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 28 | 2021-07-11 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-12 00:00:00 | Beer 1 | DH (10bbls) | - | - | - | - | - | - | - | - | - | -
 | 2021-07-13 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-14 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-15 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-16 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-17 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 29 | 2021-07-18 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-19 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-20 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-21 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-22 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-23 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-24 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 30 | 2021-07-25 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-26 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-27 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-28 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-29 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-30 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-07-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 31 | 2021-08-01 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-02 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-03 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-04 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-05 00:00:00 | Beer 1 | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-06 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-07 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 32 | 2021-08-08 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-09 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-10 00:00:00 | Beer 3 | DH (20bbls) | Beer 1 | DH (10bbls) | - | - | - | - | - | - | - | -
 | 2021-08-11 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-12 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-13 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-14 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 33 | 2021-08-15 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-16 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-17 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-18 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-19 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-20 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-21 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 34 | 2021-08-22 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-23 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-24 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-25 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-26 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-27 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-28 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 35 | 2021-08-29 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-30 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-08-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-01 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-02 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-03 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-04 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Week 36 | 2021-09-05 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-06 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-07 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-08 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-09 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-10 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2021-09-11 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -