Forum Discussion
trying to Caculate overall score for each employee using a 100-point scale
30% is one column 70% is other column how do I formulate this thankyou!
If your range starts in Row 2, this formula in C2 returns the weighted score:
=SUMPRODUCT(A2:B2,
{0.3,0.7})