Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summation Formula Needed | Excel Worksheet Functions |