Average Functions

Using the AVERAGE Function:

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:


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

Example Usage:

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:


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