Cross-Sheet Formula for Average of Column Excluding Blanks

Lori Flanigan

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,

Lori

Razetto

@Lori Flanigan The average formula should take care of eliminating the blank cells in the calculation.

https://help.smartsheet.com/function/avg