Working with MS Excel – AVERAGEIF

Excel
Spread the love

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 Reply