AVG formula Divide If Zero Error

whidbeycd

New to formulas, attempting to find the average of survey results using the AVG function and the range for an entire column ("Experience") using the following:

=AVG((Experience:Experience))

Tips on how to resolve the error? Thanks!

Mike TV

@whidbeycd

Maybe you have a cell (or all of them) that have a number in them but SmartSheet thinks it's text. Also, you don't need the double parenthesis around your formula range but it's not what's causing this problem. Try this:

=VALUE(AVG(Experience:Experience))

whidbeycd

Thanks! This still gave the same error but I think perhaps the issue was that the values were in a drop down - I just changed the Column Property to text and that fixed it