See http://www.contextures.com/xlPivot01.html
and http://www.peltiertech.com/Excel/Pivots/pivottables.htm


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Alex" wrote in message
...
I have a sheet with 60,000 rows of data. each row contains part numbers
w/house location and Quantity on hand. For many parts I have several rows
of
QOH since each W/house location has its own row of data.
I would like to create a total QOH for each part number.
Any ideas?