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 -
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.
Here it is again with the formula highlights.