I have a spreadsheet that finds the total number of times a category reason code is noted on another worksheet, but now I have to find what the total dollars are for that category reason code. How do I proceed? Use an "If" statement, a "Match" + Sumproduct statement, or ???
Attached is a sample of the spreadsheet; the Review worksheet has the categories with their count + dollar columns and the Detail worksheet the codes used with the claim value.