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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Why ecommerce hasn't taken off on social media

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's expensive and powerful…