Hi for the sample table below in excel:
<tbody>
</tbody>
<tbody>
</tbody>
I have a destination table which is as the 2nd table where in need the results sum'd by rows and columns. I have tried Sumifs and Sumproducts but i am unable to figure that out. Any help is greatly appreciated.
New York | Japan | China | Chicago | |
Product A | 3 | 5 | 1 | 2 |
Product B | 9 | 6 | 7 | 4 |
Product C | 2 | 9 | 1 | 4 |
Product D | 1 | 3 | 2 | 5 |
<tbody>
</tbody>
North America (New york &Chicago) | Asia(China&Japan | |
Product A | ||
Product B | ||
Product C&D |
<tbody>
</tbody>
I have a destination table which is as the 2nd table where in need the results sum'd by rows and columns. I have tried Sumifs and Sumproducts but i am unable to figure that out. Any help is greatly appreciated.