I have a rather large spreadsheet (~12000 entries) which contains inventory
data. I have many parts which are in multiple location, but I just want a
subtotal by part number of the quantities in all locations.

I tried subtotal, and the sheet shows the subtotals, but it opens up an
outline view or something to that effect, and I want just the summary
information on that sheet or be able to copy to another worksheet. But no
matter what I do, I either get a grand total entry or all entries, including
each location. How do I obtain just the subtotal data where I can perform
further functions like VLOOKUP (for another sheet).

I tried Pivot Table but it comes back and says something like too many items.

I'll readily admit I'm an amateur at subtotals. Can anyone help?

Thanks in advance,

Dave