I P Average Function N


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.


Lets 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

ExampleCells to averageAnswer
=average (A1:A4)A1, A2, A3, A462.5
=average (A1:A4, 300)A1, A2, A3, A4 and 300110
=average (A1:A5)A1, A2, A3, A4, A562.5
=average (A1:A2, A4)A1, A2, A458.33


I P Average Function N

1197582

 Choose:   INTEK home   I   training  I   by Jim Tracy   I