Working with MS Excel – AVERAGEIF

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

Author: wehelpf9

Leave a Reply