Calculating "sumifs" from columns depandant on row/cell content

[Stemargia]

Dear All,

Thanks for having me on the forum. I have some experience in Excel, but insufficient to automate the following:

Image 1.PNG

On the right you can see a table on which there are sales figures for some production models per month. There are several processes (in the example in total 3 processes) on which we sort them into a specific group:
Example: Model 1 is in the group "All" for proces 1, in "Group 1" for proces 2 and in "Test 1" for proces 3.

I'd like to become the table on the left in an automated way: The sum of all models, per month, for all groups for proces 1, all groups for proces 2 & all groups for proces 3.
To become the desired table in the example shown I just used: "=SUMIFS(S$4:S$25;$P$4:$P$25;$F6)" for the first cell [G6]. For cell H6 - J6 I could simply drag to the right --> no issues.
For the cells below though I manually have to select the correct "Criteria_Range". For process 1 I have to select column P, for Process 2 column Q and for process 3 Column R.

This isn't an issue for such a small table, but this is only an example. I have to process this information for a much higher number of processes.

I have tried cell referencing based on a lookup, but this fails. A Pivot table isn't usefull as well in this case.

Any suggestions on how to solve this in a semi-automated way? VBA proposals are also welcome.

Thanks in advance!

Kind regards,

Stemargia