How to average non-adjacent cells

Ldonoghue
Ldonoghue ✭✭✭
edited 06/20/22 in Formulas and Functions

I'm trying to average non-adjacent ranges. I've tried =AVERAGEIF([Range:Range],[Range:Range],"<>0"), but get an error each time.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!