SumIf + Look up query to create overview

Hello,

Fairly simple question: how do I create an overview tab where I show for each country total number of events by looking up a file that has got multiple entries for each country with different numbers for each entry.

Example in excel attached.

Many thanks!