Cross-Sheet Formula for Average of Column Excluding Blanks

Lori Flanigan
Lori Flanigan ✭✭✭✭✭
edited 06/07/23 in Formulas and Functions

I have three columns that are populated by column formulas. I need to calculate the average of each column and exclude blank cells in a different sheet.

I appreciate your help!

Thank you,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!