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
@ebrasni145
If your range starts in Row 2, this formula in C2 returns the weighted score:
=SUMPRODUCT(A2:B2,{0.3,0.7})
