Glad it helped you to find the solution in your xl2007 <g

Thanks for posting the steps in xl2007,
which benefits many other readers facing the same issue

Btw, do take a moment to press the Yes buttons (like the one below) from
where you're reading this, for all responses which helped answer your query.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---
"Susienak" wrote:
Hi Max,

I tried Pivot table the other day but I was missing something that I didnt
figure out until today. 2007 works a little different. I highighted the two
columns, went to the insert tab, clicked pivot table and ok, then dragged the
prod# to the ROWS field on the bottom right and dragged the product sales to
the VALUES field on the bottom right... BUT that automatically gives a
"count".. it counts how many times the Product number appears in the product
# row, it doesnt sum up the products sold... SO... on the bottom right under
VALUES you click on the drop down arrow and you can change the field settings
from a count to a sum... and that worked perfectly!

Thanks...