Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Product | |||
Years | Month | "A" | "B" |
2022 | Jan | 29000 | |
Feb | 29000 | ||
Mar | 29000 | ||
Apr | 29000 | ||
2023 | Jan | 50600 | 10000 |
Feb | 51600 | 10000 | |
Mar | 56000 | 10000 | |
Apr | 53500 | 10000 |
Hi, can you elaborate?
I need a wildcard formula to calculate aggregate sum sales where
For Product B, in months Jan-Apr 2022, the value should calculate as 29000 and in Jan-Apr 2023 is 10000
while for Product A, the values are different from each month.
How do I sum these together?