Find Average of Numbers in Spreadsheet

How to find average of numbers in OpenOffice Spreadsheet?

Explanation

The syntax to find out the average is, =AVERAGE ( argument1;argument2; ... argument255 )
To find out the average of numbers, follow the below steps,
Step 1: Select the cells where you want the answer to be displayed.
Step 2: Type =AVERAGE( Click and drag the cells to select and then close the bracket ).
Step 3: Press the "Enter" Key.
Example: If you want to calculate the average for the set of numbers in the cell A2 to A7, then you have to find out as given in the below image,

If you want to find out the average for only specific cells, then you can calculate by using the cell reference of those two cells as given in the below image,

Related Topics