Column Average

saraha83081
saraha83081 ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello!

I am trying to calculate the average of a column.  It seems like this should be a very simple task.

I'm typing =AVG then referencing the column I need to average from another sheet.  It generates the following formula  =AVG({Employee Reviews - PFP Range 7})

However, when I hit enter, I get a #DIVIDE BY ZERO error.  Any thoughts on how to overcome this would be greatly appreciated.  I'm sure there is something very simple that I'm missing, I just can't quite figure out what it is.

 

 

Average Formula.png

Divide By Zero Error.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!