Averaging a Column with blank entries


How would I go about composing a formula to find the average of a set of number in a column that would ignore blank cells?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!