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???


--
Solarissf
------------------------------------------------------------------------
Solarissf's Profile: http://www.excelforum.com/member.php...o&userid=34834
View this thread: http://www.excelforum.com/showthread...hreadid=549600