sumif (maybe)

[Guest]

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?

 

[Bob Phillips]

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)