Monday, September 29, 2014

Compare Percentage Result Between Excel Formula [Average] And [Averageif Exclude "0"]

Do you know the result of percentage not the same if there is the number “0” within the Range of "Average" Formula?

Therefore, how do you solve this problem?

To obviously visible what the difference of using Average Formula between the range of the number “Include 0” and “Exclude 0”.

1] Let us have a look the first sample. We have the table of the whole year of the sales amount. 

However, there are the two months, which are with the “0” sales amount(Empty cells), July and August.


We use Excel formula “=AVERAGE(AB5:AB16)” to calculate the percentage average from January-December. The outcome is 76.11%. That would be true?

2] The second sample, we use all the same data as the number one. On the other hand, we have changed the formula to use “=AVERAGEIF(AB5:AB16,"<>0")” instead. Here we gain 91.33%


It does not matter what our calculation criteria is, here, my article is just only to show you how the two formulas work in different way. You can pick any of them and use it as you want.

See more other tips:
Would you like to surf my other blogs?

No comments:

Post a Comment