Average cells ignoring zeros

{=AVERAGE(IF(CellRange<>0,CellRange))}


Related Formulas

Average cells that are numbers
Average cells that are numbers ignoring duplicates
Average cells that are numbers using weighted average


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top