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

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x