I'd do the following, as exampled in the attached workbook.
Highlight all 8000 IDs and name them IDs in the name box, or use Insert > Name > Define to do it.
I also named the data in the price columns Price1, Price2 and Price3. This makes the formulas easier to understand.
Now, below the original data, use my sample to first create a unique list of IDs. I started at A11. It finds the first unique entry, then displays it. Copy your adjusted formula down until it stops showing unique additions to the list.
Then use the formulas to the right to use the SUMIF function to group them all.
Bookmarks