Extracting total values from table of Data

[Gusher]

In Col C I have names of colours. In col D I have names of countries and Col E I have values.

I need a formula that will sum values. For example from the table what is the total value of colour = "red" and country = "Spain"


Many Thanks

 

[hagia_sofia]

Generally speaking the answer could be:

=SUMIFS(E:E,C:C,C1,D:D,D1)

where C1 would represent a color and D1 would represent a country.