Combining data

[Guest]

I am fairly new to excel and have a delima. I have two worksheets. The
first worksheet has names and numbers, the second has names and numbers as
well. The data changes in worksheet 2 from week to week. I want to input
data in worksheet 2 and have worksheet 1 look at that data and append to what
is already has. If there are duplicates, I want it to sum the data. Can you
help...Here is what I have
Worksheet 1 (This is the worksheet with the combined data)
Name Points

Worksheet 2 (This data is to be combined with worksheet 1 and duplicates
need to be sum'd making 1 (running) total.

Example Worksheet 1 Worksheet 2
Name Points Name Points
Dan 20 Bob 20
Bob 14 Dan 8
David 14

I want it to look like this

Worksheet 1
Name Points
Bob 34
Dan 28
David 14

Can anyone help...

 

[Sebation.G]

try to use Data>Consolidate

 

[Guest]

D1: holds Bob
D2: holds Dan
D3: holds David

In E2:
=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&{1,2}&"!$A$2:$A$100"),D2,INDIRECT("Sheet"&{1,2}&"!$B$2:$B$100")))

Copy down

 

[Guest]

Thanks, I'll try that...

D1: holds Bob
D2: holds Dan
D3: holds David

In E2:
=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&{1,2}&"!$A$2:$A$100"),D2,INDIRECT("Sheet"&{1,2}&"!$B$2:$B$100")))

Copy down