Averages ignoring zeros and/or blanks

[Rowan_Sutherlan]

Hi, does anyone know how to create a formula which will allow me to average the numbers in columns ignoring zeros and/or blanks?

Thanks,
Rowan

[Elias_Gomez_Sai]

AFAIK, blank values are ignored. For the zeros, could you add an IF to avoid inserting them?

[Rowan_Sutherlan]

Thanks for responding. Looks good. :grinning: