Sum if on multiple criteria

[Wolfie1]

Hi
I'm trying to work out how to use a sum if on a table to sum up a column based on various criteria.

My table kind of looks like this:

YR1 YR2 YR3 YR4 YR5
Country B 10 10 10 10 10
Country A 10 10 10 10 10
Country C 10 10 10 10 10
Country D 10 10 10 10 10
Country A 10 10 10 10 10
Country C 10 10 10 10 10
Country D 10 10 10 10 10


This then feeds into a large table with changing years (dependent on what i want to select). I tried a sumif function and selected all the numbers as the sum range and then the Year as one criteria and country as another. This just returned a value. If i was looking at YR3, country A i would want to see 20 .

Am i using the right function or is there something else that someone can recommend.
Thanks for the help

[Tony Valko]

Try this...

With your table in the range A1:F8.

Criteria:

H2 = Country A
I2 = YR3

This formula entered in J2:

=SUMIF(A2:A8,H2,INDEX(B2:F8,,MATCH(I2,B1:F1,0)))