SUMIFS - SUMPRODUCT - List of ranges as criteria

[spyrospoulis]

How to SUM values in a table, with criteria based on three columns, in each one column the criteria are many values on vertical ranges?
SUMIFS works, but for only one range as criteria, the other criteria range must be a single value.

 

[spyrospoulis]

I attached the image with the formulas, and the question is how to make the sumifs to work for criteria as three ranges (Not single values) for three columns respectively.

 

[Fluff]

Try wrapping the C2:C4 in Transpose