Averages ignoring zeros and/or blanks


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



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


Thanks for responding. Looks good.:grinning: