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