The basis of what I need from this 1) There are four columns (month, species, product, and measured units) that I need to have reduced down to unique rows based on these four columns. 2) All products have static sales prices attached to them in a fifth column - I need these to remain with their specific species/product/units combination after the table has been reduced down to the unique rows. 3) All products have total sales - along with the unique rows function, I need a sumif function that will sum the dollar and volume columns relevant to each unique month/species/product/units result. I've been kind of getting success by breaking this down into steps within my sheets, but as you can see in the FY2020 sheet, there are mistakes occurring in the longer data sets and I could really use some help simplifying this. Hopefully you can help! Ben