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”.
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:
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.
However, there are the two months, which are with the “0” sales amount(Empty cells), July and August.
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:
- 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)
- How To Display The Data Entry In All Empty Cells On The Left Of Pivot Table
- Quick And Easy Way To Paste Data To Multiple Cells In An Excel Worksheet
- [Resolve] Excel – Why Can't I See The "0" In My Excel Workbook?
- Excel Trick to Make a New Unconventional Graph with “REPT ( )” Formula
- Trick How To Delete The Same Data In Multiple Places With An Easy Way
- Ctrl+Shift+_ Excel Shortcut Erase The Selected Lines Border Of Cells
- Removes Unwanted Spaces Leading, Trailing And Between Words From The Text String
- VLOOKUP Searches For Value From Table Array In The First Column Return Value The Same Row