name 1997 1998 1999 total
raju 1
venu 2
somu 2
raju 5
rani 3
venu 3
somu 3

all the names should be grouped & totalled as per the year
is there any formula or function