sumif (maybe)
 

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?

sumif (maybe)
 

Alex, use a pivot table (in data/pivot table). once table form is created,
drag part number to rows field and QOH to data field. This will give you
your QOH by part number.

"Alex" wrote:

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?

sumif (maybe)
 

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?