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! |
|
| 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
|
