Excel Average (Mean) EXCLUDING Zero values

  stubacka2 09:19 07 Jul 06
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 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.
=COUNTIF(B2:B7,">0")
Noldi

  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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…