• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 616
  • Last Modified:

Excel 2010 Conditional Sum

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?)
Discount-Percentage.xlsx
0
mark_harris231
Asked:
mark_harris231
  • 2
1 Solution
 
mark_harris231Author Commented:
To paraphrase the "ask", I'm looking for a formula I can place in Cell E2 and drag down over the full range of my production data without requiring me to change the SUM ranges.
0
 
Ken ButtersCommented:
in cell F2.... (or replace E2 if you prefer....

=D2/SUMIF(A:A,A2,D:D)

then fill down.  

(then change cell format of new column to %).
0
 
mark_harris231Author Commented:
Perfect....and a helluva lot easier than I thought it had to be.  O|o

Thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now