Hi,
I have a query related to SUMPRODUCT with multiple criteria in Rows and Columns.
Using the below example to explain the problem.
I have data of sales figures of various products belonging to different categories for different quarters over a few years. Am trying to calculate the total Value for each category for a full year.
<colgroup><col span="2"><col><col span="8"></colgroup><tbody>
</tbody>
I want to get the result without using any helper columns (adding full year numbers in helper columns).
Required result in below format
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks for your help
I have a query related to SUMPRODUCT with multiple criteria in Rows and Columns.
Using the below example to explain the problem.
I have data of sales figures of various products belonging to different categories for different quarters over a few years. Am trying to calculate the total Value for each category for a full year.
2017 | 2017 | 2017 | 2017 | 2018 | 2018 | 2018 | 2018 | |||
Product | Category | Unit value ($) | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 |
A | Regular | 4 | 57 | 29 | 42 | 31 | 80 | 39 | 38 | 43 |
B | Regular | 5 | 29 | 55 | 50 | 67 | 26 | 80 | 70 | 31 |
C | Super | 8 | 40 | 57 | 66 | 80 | 77 | 62 | 57 | 70 |
D | Super | 9 | 65 | 51 | 38 | 48 | 55 | 36 | 77 | 79 |
E | Super | 7 | 76 | 61 | 39 | 41 | 57 | 45 | 68 | 58 |
F | Regular | 6 | 25 | 77 | 31 | 53 | 38 | 35 | 74 | 25 |
<colgroup><col span="2"><col><col span="8"></colgroup><tbody>
</tbody>
I want to get the result without using any helper columns (adding full year numbers in helper columns).
Required result in below format
Category | 2017 | 2018 |
Regular | ||
Super |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks for your help