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?