Dear friends & members
I have a data on 1 single sheet in the below form (just an example) in
which 1 cell shows month, second shows name and third shows again
result my problem is that i want the total result in another form
Month    Name    Score
jan    Bob    100
jan    Tim    80
jan    Jim    90
feb    Jim    87
feb    Tim    67
feb    Bob    56
mar    Jim    87
mar    Tim    94
mar    Bob    46
apr    Bob    97
apr    Tim    59
apr    Jim    75

which is stated below
Name    Jan    feb    mar    apr    total
Bob    100    56    46    97    299
Tim    80    67    94    59    300
Jim    90    87    87    75    339

The problem is that name are not in the symetric form (name are up and
down in every month).  i want to use vlookup for picking the right
value but the thing is that I want that it should pick up right value
for right month
Any other way just tell me also....

hope you understand by the example thank you

thanks for advance
dhir