Working with MS Excel – AVERAGEIFExcel / February 3, 2018 / Leave a Comment Working with MS Excel – AVERAGEIF Hi, We can easily calculate average by ignore the zero (0) in the list e.g. Formula is = AVERAGEIF(B2:B13,”<>0″)