Sum with criteria in a table

  • Hello,

    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%.

    Evaluation sheet.xlsx

    That's probably a poor explanation of the problem - apologies - but my brain just can't figure it out.

    Any help appreciated.

    Kind regards,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!