Hi guys,

I need your help to build a company offer comparison system based on 3 things : criteria, coefficient and notation (Cf. screen below)

**The formula would be :**

Score offer 1 = Sum(coef*notation) = (coef 1 * notation 1) + (coef 2 * notation 2) = (coef 3 * notation 3).

I did manage to use the SumProduct formula even if it’s still red, it works…

**Do you know why ?**

**I just need to sum all the scores now : Sum(n Scores) = Score 1 + Score 2 + Score 3 + … + Score n**

**where n = number of criteria.**

Any clue please ?

Thanks a lot for helping !