Artikel zum Thema:

Using the AVERAGE function


Spreadsheet Editor offers you over 440 built-in functions that you can use when working with your spreadsheet data. This article explains how to use the AVERAGE function.

The AVERAGE function is one of the statistical functions that is used to analyze the range of data and find the average value. To calculate the average, this function adds all the numeric values and then divides the result by the total number of values.

The AVERAGE function has the following syntax:


where argument-list is a group of numeric values you want to calculate the average value for.

Note: You can instantly view the average for a certain data range without applying formulas by highlighting the necessary cell range. The AVERAGE value is automatically calculated and displayed in the lower right corner at the status bar. If you need to display the average value for several nonadjacent cells or cell ranges, hold down the Ctrl key when selecting them.

Step 1. Apply the AVERAGE function

To apply the AVERAGE function, follow these steps:

  1. select the cell where you wish to display the result,
  2. switch to the Formula tab,
  3. click the More functions button at the top toolbar,
  4. select the Statistical menu item,
  5. choose the AVERAGE function from the list,
  6. enter the required arguments separating them by commas.
average function Step 1 average function Step 1

Alternatively, you can add the AVERAGE function in one of the following ways:

  1. start adding the function:
    • switch to the Home tab, click the Insert Function Insert function icon icon situated at the top toolbar and select the Additional option,
    • or right-click within a selected cell and select the Insert Function option from the contextual menu,
    • or click the Function icon icon situated before the formula bar,
  2. in the Insert Function window, select the Statistical function group from the list,
  3. click the AVERAGE function and press the OK button,
  4. enter the required arguments separating them by commas.

Note: it's possible to add up to 255 arguments.

The arguments can be numeric values, named ranges, or references to cells or cell ranges that contain numbers. If the selected cell range contains text values, logical values and empty cells, they are ignored. Zero values (0) are counted.

average function Step 1 average function Step 1

When the arguments are specified, press the Enter key. The result will be displayed in the selected cell.

average function Step 1 average function Step 1

In this example, the average of numeric values in cells C1:C5 is calculated. Cell C1 contains text and cell C5 is empty, therefore they are ignored.

That's all. Now you can easily average multiple numbers using the AVERAGE function.

How to create a new document?
Try now for free Try and make your decision No need to install anything
to see all the features in action
Wer sich dafür interessiert hat,
hat auch das Folgende gelesen: