Forum Discussion
Find matching values in column cells and the sum of of the cells in the rows of each matching cell
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
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
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.
| Clock | Last | First | Event | Date | Sum | Comment |
| 358 | Smith | Joe | no show | 2/10/2021 | 8.2 | Test |
| 358 | Smith | Joe | no show | 2/10/2021 | -8.2 | Test |
| 358 | Smith | Joe | no report | 2/11/2021 | 8.2 | Test |
| 456 | Smith | Ted | no show | 02/01/2021 | 8.2 | Test |
| 456 | Smith | Ted | no report | 02/16/2021 | -8.2 | Test |
| 456 | Smith | Ted | no report | 02/16/2021 | 8.2 | Test |
| 456 | Smith | Ted | FMLA | 02/15/2021 | 8 | Test |