Average Functions

The syntax for the AVERAGE function is as follows:

=AVERAGE(number1, [number2], ...)

number1 is the first number or range of numbers you want to include in the average.
[number2] (optional) is the second number or range of numbers, and you can include additional numbers as needed.

Here's an example:

Let's say you have a range of numbers in cells A1 to A8, and you want to find the average:

=AVERAGE(A1:A8)

This formula will calculate the average of the numbers in cells A1 through A8.

Suppose the values in cells A1 to A8 are 10, 15, 20, 25, 30, 35, 40, and 45, respectively. You can enter the following formula in a cell:

=AVERAGE(A1:A8)

After pressing RETURN, Excel will display the result, which is the average of the numbers in the specified range.

Related Topics

=> Introduction of Excel
=> User Interface
=> The Excel Interface: Application Window
=> The Excel Interface: The Workbook Window
=> Creating, Opening and Exporting Workbook and Compatibility mode
=> Understanding Cell, Cell content
=> Modify Row, Colums and Cell, Wraping text and Merging text
=> Excel Shortcut Key
=> Home Tab: Clipboard Font Formatting, Text Alignment
=> Home Tab: Number, Styles, Cell, Editing
=> Addition and the SUM Function
=> Subraction (Minus)
=> Multiply and PRODUCT Function in Excel
=> Divide or Division
=> Reminder in Excel
=> Max Function in Excel
=> Min Function in Excel
=> Average Functions
=> Count Functions
=> Counta Function

Follow Us