I would like to have a part number(column A) order qty combined by by the total of a certain qty. required (column d) combined throughout the entire worksheet. Maybe an extra sheet at the end stating all the part numbers (duplicates removed with the totals of the part number quantity total retained from the entire worksheet. I tried Find, sum IF, match. I believe I'm going about this incorrect, any help would be appreciated! thanks!Purchase.xlsx