Hello everyone, I am working on a sales workbook for a grocery store and I have an issue with duplicate entries. The sales data for a given time period counts sales when an item is on sale as a separate entry from sales when the item is not on sale. I want to find total sales for each item and then remove duplicate rows so the workbook is easier to analyze. I have attempted the following: find sales data by using the array function =sum( ($UPC column = UPC 1) *(sales column)). This gives me a sum for each entry but by then removing duplicates I cannot keep the correct sums because they reference rows I have removed. Is there a way I can merge two rows sales data and keep only the merged row? Or associate the sales sum with a UPC so when I remove duplicates I can retain the correct sum? Please let me know if I can provide additional information to clarify my problem. Thank you.