1/1/2019 | 2/1/2019 | 3/1/2019 | 4/1/2019 | 5/1/2019 | 6/1/2019 | 7/1/2019 | |
Product 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Product 2 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |
Product 3 | 0 | 1 | 1 | 2 | 0 | 0 | 0 |
Product 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Product 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Product 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Product 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Product 2 | 0 | 1 | 1 | 1 | 5 | 32 | 20 |
Product 3 | 60 | 45 | 49 | 40 | 62 | 41 | 69 |
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Looking for help to get this SUMPRODUCT to work, using excel 2016
SUMPRODUCT((A2:A10="Product 1")*(A2:A10="Product 3")*(B1:H1=D1),B2:H10)
Thanks