C4 is the total quantity of units being sold and I would like to divide column D (the total amount of replacements) from this in order to get the percentage of units needing to be replaced. Then, for each column (new acct, damaged, missing, etc.) this would divide into column C to give me a percentage for each issue by itself. Let me know if this makes since and thank you!
|