top of page

You are learning Functions and Formulas in MS Excel

How do I calculate the average with the AVERAGE function?

To calculate the average of a range of numbers in Excel, you can use the AVERAGE function. Here's how:

1. Enter the Formula:

In the cell where you want the average to be displayed, type the following formula:

```excel
=AVERAGE(range)
```

2. Replace "range" with the actual cell range:

* The "range" argument refers to the group of cells containing the numbers you want to average.
* You can enter the cell range directly (e.g., A1:A10) or select the cells with your mouse.

Examples:

* To find the average of cells A1 to A10, you would enter:
```excel
=AVERAGE(A1:A10)
```
* To find the average of cells B2, C2, and D2, you would enter:
```excel
=AVERAGE(B2:D2)
```

3. Press Enter:

Once you've entered the formula with the correct cell range, press Enter on your keyboard. Excel will calculate the average of the values in the specified range and display the result in the cell.

Additional Notes:

* The AVERAGE function can handle up to 255 numeric arguments.
* Empty cells, text values containing numbers, and cells with zero values are included in the calculation.
* Text strings and cells with error values (e.g., #NA) are ignored.
* If you want to include logical values (TRUE or FALSE) and text representations of numbers in the calculation, use the AVERAGEA function instead.
* For calculating the average based on specific criteria, explore functions like AVERAGEIF or AVERAGEIFS.

bottom of page