Skip to main content

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

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

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


Thanks for responding. Looks good. :grinning:

Terms & ConditionsAccessibility statement