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
click hereand scroll about one third down the page, stubacka2.
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
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.
iMac Pro review
Illustrator Charles Williams on how to create magazines and book covers
Les meilleures prises CPL (2018)
© Copyright 2018 IDG UK. All Rights Reserved.