How to do Weighted AVG in smartsheet?

We are having a feedback that tells us the rating per questions, as the image shows, it has the number of counts per rating.

Now, how do I get the Weighted Average if the number of respondents of the form keeps changing since it is an ongoing session (daily)?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!