Excel tutorial : Average Function in excel

Excel tutorial : Average Function in excel

There are many functions built into many spreadsheets. One of the first ones that we are going to discuss is the Average function. The average function finds the average of the specified data. (Simplifies adding all of the indicated cells together and dividing by the total number of cells.) The syntax is as follows.

• =Average (first value, second value, etc.)

Text fields and blank entries are not included in the calculations of the Average Function.

---

Let's use the table here for the discussion that follows: We will look at several different specific examples that show how the average function can be used!

A 1 25 2 50 3 75 4 100 5

---

Example	Cells to average	Answer
=average (A1:A4)	A1, A2, A3, A4	62.5
=average (A1:A4, 300)	A1, A2, A3, A4 and 300	110
=average (A1:A5)	A1, A2, A3, A4, A5	62.5
=average (A1:A2, A4)	A1, A2, A4	58.33