With reference to the attached/uploaded example... For each supplier I wish to show a "Supplier Final Weighted Score" (SFWS) for each row of that Supplier. The SFWS should be the unique sum of the "Section Final Weighted Score" by Supplier. In the example Comp1 should total 42% (Section A 9% + Section B 15% + Section C 9% + Section E 6% + Section F 3%), but I've got it stuck on too much uniqueness and it's not adding in one of the 9%'s, resulting in SFWS = 33% rather than 42%.
That's probably a poor explanation of the problem - apologies - but my brain just can't figure it out.
Any help appreciated.