Summation and Lookup

[Solarissf]

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

[Ardus Petus]

To add entries (de-dupe from original list), use >data>Filter>Advanced
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" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> 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
>