Averages ignoring zeros and/or blanks


#1

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


#2

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


#3

Thanks for responding. Looks good.:grinning: