Find matching values in column cells and the sum of of the cells in the rows of each matching cell

Haytham Amairah I am attempting to do something very similar but I am trying to match multiple columns/rows of data and bring back a sum.  Example below:  if A2-E2 match exactly A3-E3 then total the sum of those matching rows, which should come back as zero (8.2-8.2 or F2+F3).  I put this all in a pivot but need the zeros to not show.  I only need the unique row's sum, and the comment needs to show for each one.  I appreciate any ideas.  I have tried a calculated field in a pivot but it wont pull the comments. 

This is SO helpful! Thank you! Here is a followup question. Do you know if there is a way to automatically delete from the first sheet the rows that have an aggregate value from Column B in the summary that have a value below a certain number? For example, if the threshold is "300" would it be possible to automatically delete the source data for Jim and Joe because their aggregated column B data is less than 300. I hope that makes sense. 

---

Haytham Amairah wrote:

Hi Bill,

 

The easiest way to do this is by using the PivotTable as the below screenshot:

 

To learn more about PivotTables, please check out this https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-A9A84538-BFE9-40A9-A8E9-F99134456576 and https://www.excel-easy.com/data-analysis/pivot-tables.html.

 

Hope that helps

---