I have been trying to use :subtotlas, consolidate, IF, & pivottables to get a
spreadsheet of inventory #'s (same part # in various cells) and want to
aggregate/consolidate those to 1 record with a TOTAL QTY value that I can
then use to import to a program.

I have tried the if command and get no values
I have not been able to successfully use the consolidate function
the subtotals function kind of works BUT does not give me the summed total
on 1 line with the part # for export
And pivot table method returns a COUNT on the qty field NOT a sum of all
same part # ???

Suggestions please I am stuck