how to rank individuals with their corresponding figures

Dear All,

I wanted to rank individuals and get their total amount.

For Example

Jan FEB
A 20 A 30
B 30 B 50
C 40 C 30


Desired result
1 B 80
2 C 70
3 A 50

Thank you

Duplicate post: see other post for response.

http://www.excelforum.com/showthread.php?t=1169167