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 between using Average Formula between the range of the number “Include 0” and “Exclude 0”.


1] Let us have a look at the first sample. We have the table for 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 a different way. You can pick any of them and use it as you want.
Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.

See more other tips:

• How To Align Number To Be At The Center Of Active Cell(S) In Excel's Workbook
• How To Escape Away From “Header And Footer” To "Normal View" | Exceltip2day
• Technical Tip To Select Or Copy Data Entered Between Range Of The Particular Cells And Uppermost Cell (A1)