I recently participated in a question that had a similar "theme", but I can't seem to track it down and I need some assistance in a similar issue.
I have a spreadsheet that contains four columns: DISC_CODE_GROUP, DISC_MIN, DISC_MAX and DISC_$. The values under DISC_CODE_GROUP will repeat multiple times within a series of MIN and MAX values. DISC_$ is the amount of sales at each discount level.
I need to add a column that shows me the % of each row of DISC_$ for the DISC_CODE_GROUP it belongs to. In the attached example, I manually set my SUM ranges with absolute references, but I would like something that evaluates the DISC_CODE_GROUP and sums the value in DISC_$ if they belong to the same discount group.
I think I need to do a SUMIF/INDEX/MATCH expression, but struggling with the syntax. (Or maybe this could be done with a pivot table?)