SUMIFS for dynamic range

[Keibri]

Hi guys,

I would like to ask whether someone can help me out with the below.

Basically I have a matrix with currencies (e.g. Eur) on the y-axis (columns) and name of cities on the x-axis (rows).

I would like to sum all instances of e.g. EUR against Milan. Usually a simple sumif will do the trick. However my problem is that the range from where the sumif will be picking up is going to be dynamic. That is, example, 'Milan' will not always be in column E.

For ease of reference I have attached a sample.

Is there a way I can go about it? Not sure if a sumproduct could be used, or any other alternative which is not as slow as an array?

Much appreciated and thanks a lot for your help.

Best Regards

Keibri