From the course: Excel Formulas and Functions Quick Tips

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Find the mean value with AVERAGE

Find the mean value with AVERAGE - Microsoft Excel Tutorial

From the course: Excel Formulas and Functions Quick Tips

Start my 1-month free trial Buy for my team

Find the mean value with AVERAGE

“

- [Instructor] The average function returns the arithmetic mean of numbers. It's calculated by adding a group of numbers and then dividing by the count. This function ignores cells containing text or empty cells. Type =AVRAGE, open the parentheses, and then you can specify numbers separated by commas, individual cell values, or you can also select a range. Close the parentheses, hit Enter, and you'll get the average. It's important to note that you can also select your range and look down at the bottom right hand side of the screen to view the average. The AVERAGEA function is similar, except you can also include numbers represented as text and true and false values as 1 and 0. Any cell containing other text will have a reference value of 0.

Contents