Working with MS Excel – AVERAGEIF

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″)

Leave a Comment

Your email address will not be published. Required fields are marked *