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