Excel combine rows dollar amount with matching row values?

Sounds like a job for pivot table!

Highlight your table and go to Insert → pivot table and arrange it how you want. I'd do the following -

enter image description here


In my opinion, the pivot table/report is the way to go. But if you would rather have the results below the table, you can use the SUMIFS function to total the dollars which meets the product key criteria in the range you specify. You can use multiple criteria if needed.

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Below I used the example to build subtotals below the table.

enter image description here

Here it is again with the formula highlights.

enter image description here