Excel Average (Mean) EXCLUDING Zero values

  stubacka2 09:19 07 Jul 2006
Locked

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.
=COUNTIF(B2:B7,">0")
Noldi

  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

Fujitsu Lifebook P727 laptop review

11 best portfolio websites for designers and artists

Office for Mac buying guide: Price, Office 2017 rumours & new features

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?