Excel

[fareed faadi]

I have two sheets. Sheet 1 have names and amount and sheet 2 also have names and amount. I want to mix both sheets if names are same in both sheet then the amount of both sheets are added like this
Sheet 1
Nadi 10
haji 20
Kashi 50
ghani 70

Sheet 2
xyz 20
nadi 30
kashi 69
abc 73

i want to have all list in sheet 3 with all names if names are repeated then amount will added like nadi in sheet 1 10 in sheet 2 30 in sheet 3 becomes 40 with all names. how i get these result. please help me

[Special-K]

Rule 1

http://www.excelforum.com/forum-rule...rum-rules.html