Oct 11 2019 12:08 PM - edited Oct 11 2019 12:08 PM
30% is one column 70% is other column how do I formulate this thankyou!
Oct 11 2019 09:38 PM
If your range starts in Row 2, this formula in C2 returns the weighted score:
=SUMPRODUCT(A2:B2,
{0.3,0.7})