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