Getting a #divide by zero message on simple formula

Hi I'm getting a #divide by zero message when attempting a simple AVG formula below:

=AVG([Total Percentage Score]191:[Total Percentage Score]207)

The data is simply showing tasks that are 0% or 100%


its working ok as a formula on another sheet!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!