The format of the mapping and data needs to be as shown. I am able to pull out individual pieces, but can't piece them together....
For code DD, get the percentage of DD in each Category, and sum together.
Need help converting this logic into a sumproduct type of formula
-
-
Try.............
In K12, array formula (ctrl+Shift+Enter) copied across and down :
=SUM(($C$1:$I$8=K$11)*N(+$B$1:$H$8)*TRANSPOSE($A12:$H12))
-
To understand how does a formula work ?
Select your formula, then in the ribbon click "Formulas" >> "Formula Auditing" >> select "Evaluate Formula" >> click "Evaluate", Excel will step through the parts of the formula individually.
Regards
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!