I have a spreadsheet with a number of row records containing `country/value`

pairs (**A2:C11**) and row records representing `regions`

listing those `countries`

horizontally (**14:16**):

What I would like to do is to sum up all the country values for each region:

Conceptually I know what I need to do, for instance for North America (**B19**):

- filter
**B2:B11**range where**B**found in row**14** - sum up values from
**C2:11**corresponding to filtered**B2:B11**range

Which in this case would give `10 (C2) + 11 (C5) + 12 (C10) = 33`

I believe the functions I need are the lookup and reference functions, but I just have no idea as to where to start:

**Can someone give me an example for B19 (or at least list of functions I should be using)?**

*PS: I don't want to use VBA, just formulas*