Dear All
I want to sumif the Quantity supplied for 2019 (in Row J) and 2020 (in Row K) for each companies (A,B,C) based on the data from Row B-I.
How do i do that?
I want to sumif the Quantity supplied for 2019 (in Row J) and 2020 (in Row K) for each companies (A,B,C) based on the data from Row B-I.
How do i do that?
Column | B | C | D | E | F | G | H | I | J | K |
DATE | QTY SUPPLIED | DATE | QTY SUPPLIED | DATE | QTY SUPPLIED | DATE | QTY SUPPLIED | QTY SUPPLIED IN 2019 | QTY SUPPLIED IN 2020 | |
Company A | 9/12/2019 | 72 | 16/12/2019 | 144 | 17/12/2019 | 24 | 6/1/2020 | 80 | ||
Company B | 31/10/2019 | 120 | 2/1/2020 | 80 | ||||||
Company C | 19/12/2019 | 2 | 31/1/2020 | 12 | 20/4/2020 | 6 | 29/5/2020 | 12 |