how to calculate aggregate numbers based on a certain criteria

Hi Guys,

I really need some help aggregating some data on a worksheet.
My data sheet looks something similar to this

country_a country_b year value value2
usa can 1990 1 2
usa can 1992 4 2
usa can 1992 3 4
usa can 1993 4 5
usa can 1994 0 2
uk fra 1990 2 4
uk fra 1990 4 5
uk fra 1990 3 2
uk fra 1993 4 5

so that the output aggregates the total years so that the data comes out as
usa can 1990 1 2
usa can 1992 7 6
usa can 1993 4 5
usa can 1994 0 2
uk fra 1990 6 9
uk fra 1993 4 5


Please, any help is appreciated!!

Thank you so much.
Sincerely,

Peter

Assuming your data in the range a1 through e10


A22=countrya
B22 =countryb
C22 =year
A23=usa
B23=can
C23=1990
D23= =DSUM($A$1:$E$10,4,A24:C25)
E23= =DSUM($A$1:$E$10,5,A24:C25)

A24=countrya
B24=countryb
C24=year
A25=usa
B25=can
C25=1992
D25= =DSUM($A$1:$E$10,4,A26:C27)
E25= =DSUM($A$1:$E$10,5,A26:C27)

and so on