You just need the first 2 columns.
Select them and create a pivot table using that data.
1 - Insert "PN" in the "Row" section of the pivot.
2- Insert "Lookup Total" (in a sum format) in the "Row" section of the
pivot.
3 -Done.You will have the total by PN.
4- Whenever you add more values to column "A" and "B", you just need to
update the pivot Table and the totals will change automatically.
--
Portuga
------------------------------------------------------------------------
Portuga's Profile:
http://www.excelforum.com/member.php...fo&userid=6385
View this thread:
http://www.excelforum.com/showthread...hreadid=540462