excel translation
=+AVERAGE(SUMPRODUCT(F$13:F$19,$D$13:$D$19)/SUM($D$13:$D$19),F20,F21)
Best Answer
-
Does this answer your question?
https://community.smartsheet.com/discussion/10176/weighted-average-sumproduct
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Does this answer your question?
https://community.smartsheet.com/discussion/10176/weighted-average-sumproduct
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Excellent @Mark Cronk
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!