Excel Average (Mean) EXCLUDING Zero values

  stubacka2 09:19 07 Jul 2006

Is there a way to calculate the Average (Mean) in an Excel worksheet but to exclude zetro values from the calculation.

I know that empty cells are excluded but some values on the sheet are actual zero values that need to be there but excluded from the Mean calculation

  MAJ 09:26 07 Jul 2006

click here

and scroll about one third down the page, stubacka2.

  Noldi 11:47 07 Jul 2006

Use the Count if fiunction to get the amount of cells with more than zero then dvide the total by this.

  stubacka2 12:36 11 Jul 2006

Thanks to both for the solution.

Apologies for the delay - system problems at work.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)