Hello!
I need help coming out with a formula that does the following:
On F2 it shows the sum of B collumn if the Category and Month matches, and divide the Price by 10.
Then on G2 I want it to show the same calculation + whatever new value there is new for the month also divided by 10.
And so on.
I made it manually for the categories 2.13.01 and 2.13.02 as to explain visually my end goal.
Thank you in advance!
I need help coming out with a formula that does the following:
On F2 it shows the sum of B collumn if the Category and Month matches, and divide the Price by 10.
Then on G2 I want it to show the same calculation + whatever new value there is new for the month also divided by 10.
And so on.
I made it manually for the categories 2.13.01 and 2.13.02 as to explain visually my end goal.
Thank you in advance!
Book1 | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |||
1 | Category | Price | Date | 01/01/2022 | 01/02/2022 | 01/03/2022 | 01/04/2022 | 01/05/2022 | 01/06/2022 | 01/07/2022 | 01/08/2022 | 01/09/2022 | 01/10/2022 | 01/11/2022 | 01/12/2022 | 01/01/2023 | 01/02/2023 | 01/03/2023 | 01/04/2023 | 01/05/2023 | 01/06/2023 | 01/07/2023 | ||||
2 | 2.13.01 | 450 | 02/07/2022 | 2.13.01 | 60 | 60 | 60 | 60 | 60 | 60 | 105 | 105 | 105 | 105 | 45 | 45 | 45 | 45 | 45 | 45 | ||||||
3 | 2.13.02 | 850 | 02/07/2022 | 2.13.02 | 5 | 5 | 5 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 85 | 85 | 85 | |||||||||
4 | 2.13.03 | 900 | 30/09/2022 | 2.13.03 | ||||||||||||||||||||||
5 | 2.13.04 | 200 | 30/10/2022 | 2.13.04 | ||||||||||||||||||||||
6 | 2.13.05 | 950 | 03/01/2022 | 2.13.05 | ||||||||||||||||||||||
7 | 2.13.06 | 450 | 02/02/2022 | 2.13.06 | ||||||||||||||||||||||
8 | 2.13.07 | 850 | 03/05/2022 | 2.13.07 | ||||||||||||||||||||||
9 | 2.13.08 | 750 | 04/03/2022 | 2.13.08 | ||||||||||||||||||||||
10 | 2.13.09 | 250 | 04/03/2022 | 2.13.09 | ||||||||||||||||||||||
11 | 2.13.10 | 150 | 31/08/2022 | 2.13.10 | ||||||||||||||||||||||
12 | 2.13.01 | 600 | 03/01/2022 | |||||||||||||||||||||||
13 | 2.13.02 | 50 | 03/04/2022 | |||||||||||||||||||||||
14 | 2.13.03 | 800 | 04/03/2022 | |||||||||||||||||||||||
15 | 2.13.04 | 850 | 30/10/2022 | |||||||||||||||||||||||
16 | 2.13.05 | 900 | 04/03/2022 | |||||||||||||||||||||||
17 | 2.13.06 | 400 | 04/03/2022 | |||||||||||||||||||||||
18 | 2.13.07 | 600 | 03/04/2022 | |||||||||||||||||||||||
19 | 2.13.08 | 550 | 03/01/2022 | |||||||||||||||||||||||
20 | 2.13.09 | 250 | 31/08/2022 | |||||||||||||||||||||||
21 | 2.13.10 | 300 | 30/10/2022 | |||||||||||||||||||||||
Sheet1 |