Summation and Lookup
 

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

Summation and Lookup
 

To add entries (de-dupe from original list), use dataFilterAdvanced
Filter with copy option and Unique records only.

For summation, use formula:
=SUMIF(Sheet2!A1:A999,A1,Sheet2!B1:B999)

For automating the whole process, you would need a VBA macro.

HTH
--
AP

"Solarissf" a écrit
dans le message de news:
...

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