This function calculates the average from a list of numbers. If the cell contains zero 0, the cell will be included in the average calculation, but if the cell is blank or contains text, the cell will not be used in the average calculation.
Syntax: =AVERAGE(Range1,Range2,Range3... through to Range30)
Here is the video tutorial of the same for clear understanding.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at firstname.lastname@example.org