I have a table with values. On the y axis i have 3 types (A, B and C). On the x-axis I have calendar weeks (42, 43, 44, 45, 46, 47, 48 and 49). I know how to do a SUMIF for this task. However in my table every calendar week occurs 7 times.
I need to sum all values in the table according to the 3 individual types and 8 individual calendar weeks.
attaches is an excel file which shows the table in sheet1 and the desired output in sheet 2.
The location of the cells must not be changed. Ideally I do not want to use a macro.
Thanks in advance for your help.