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?
|