software

Hello,

I added a example.xls :
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: www.excelforum.com/member.php...oamp;userid=33279
View this thread: www.excelforum.com/showthread...hreadid=540462
You just need the first 2 columns.
Select them and create a pivot table using that data.

1 - Insert quot;PNquot; in the quot;Rowquot; section of the pivot.
2- Insert quot;Lookup Totalquot; (in a sum format) in the quot;Rowquot; section of the
pivot.
3 -Done.You will have the total by PN.
4- Whenever you add more values to column quot;Aquot; and quot;Bquot;, you just need to
update the pivot Table and the totals will change automatically.--
Portuga
------------------------------------------------------------------------
Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
View this thread: www.excelforum.com/showthread...hreadid=540462
Thx for the reply.
However I don't understand how to add that lookup Total --
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: www.excelforum.com/member.php...oamp;userid=33279
View this thread: www.excelforum.com/showthread...hreadid=540462
I dont know if you ever created a pivot tble or not so:

1 - Select Rows quot;Aquot; and quot;Bquot;
2- go to quot;Dataquot; and select quot;Pivot Table and...quot; and click quot;Finishquot;
3 - You should have a pivot in a new worksheet. quot;Right clickquot; on it
select quot;Wizard...quot; and quot;Layoutquot;
4- Drag PN to the quot;Rowquot; section an drag quot;Lookup Totalquot; to the data
section.
5- You should have the pivot.
quot;Right clickquot; on the quot;Count of Lookup Total Costsquot; tab in the pivot,
select quot;Field Settingsquot; and instead of quot;countquot; you should choose quot;Sumquot;--
Portuga
------------------------------------------------------------------------
Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
View this thread: www.excelforum.com/showthread...hreadid=540462
Ok - Thanks a lot again.
I got it now.. never used a pivot before,always did stuff manually.

But I'm beginning to like pivots --
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: www.excelforum.com/member.php...oamp;userid=33279
View this thread: www.excelforum.com/showthread...hreadid=540462