Excel Average (Mean) EXCLUDING Zero values

  stubacka2 09:19 07 Jul 06

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 06

click here

and scroll about one third down the page, stubacka2.

  Noldi 11:47 07 Jul 06

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 06

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos