Hello.
I have the following table (assume there is data), but the format is like below:
On a separate tab I need to sum and lookup for all Product 1 data based on a few criteria: Month and whether Actual or Budget. Also note that month is merged across three cells (for instance June is merged and centered (B1D1). So on a separate tab if I need July and Actual, I will need to see all the sums by Product 1, 2, 3 etc.
I believe I need to use sumifs(index(match) formula, but it doesnt seem to work.
Thanks for help.
I have the following table (assume there is data), but the format is like below:
A | B | C | D | E | F | G | |
1 | June | July | |||||
2 | Actual | Budget | Variance | Actual | Budget | Variance | |
3 | Product 1 | ||||||
4 | Product 1 | ||||||
5 | Product 1 | ||||||
6 | Product 2 | ||||||
7 | Product 3 | ||||||
8 | Product 3 |
On a separate tab I need to sum and lookup for all Product 1 data based on a few criteria: Month and whether Actual or Budget. Also note that month is merged across three cells (for instance June is merged and centered (B1D1). So on a separate tab if I need July and Actual, I will need to see all the sums by Product 1, 2, 3 etc.
I believe I need to use sumifs(index(match) formula, but it doesnt seem to work.
Thanks for help.