Skip to main content

Averages ignoring zeros and/or blanks

  • June 5, 2018
  • 2 replies
  • 55 views
R

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 replies

    E
    Forum|alt.badge.img+17

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

    R

    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