Hello,

I added a example.xls :
http://www.geocities.com/dt1337/example.zip

Col A hast a list of (PN)Partnumbers, they are not unique. So some are
listed several times.
Each PN has a different price assigned, in Col B.
In Col C I remove any double entries,the PNs are unique.
In D I remove the blanks of Col C.
In Col E, I how often a unique PN of Col D is to be found in the
non-unique list in Col A.

(Note: No formulars are in the sheet,i just copied some of the values)

My Problem is, I want to sum the total costs of a unique PN.
Ie. PN 81-1323 is multiple times in Col A and every time has a
different cost.
How do I sum up the overall costs per PN?


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=540462