Another type of question everyone:

Say I have 2 Sheets, Sheet1 and Sheet2

Sheet 2 has the following data:
A B
PE001 10
PE001 10
PE002 20
PE002 10
PE002 10
PE002 10

I'm looking for a function for Sheet1, that will ADD all the entries in B for the same name in A.

Meaning
on sheet1 I want to return this value

For PE001, 20
For PE002, 50

ADDS ALL ENTRIES AND SUMMATES THEM, TOTALS

ANY IDEAS???