How to Use the Average Function in Excel: Excel Function

How to Use the Average Function in Excel: Excel Function covers the essential facts behind the topic, including what changed, why it mattered, and how it affected users.

• How to combine Sumif and Vlookup functions in Excel
• How to use Lookup function in Excel
• How to use Vlookup function in Excel

1. How to Use the Average Excel Function

Average function syntax is = AVERAGE (number1, [number2],.).

Inside:

• Number1: The first argument can be the number, cell reference or range containing the number you want to average, required.
• Number2: is the number, cell reference or range containing additional numbers that you want to calculate up to 255 numbers, optional.

Users should note when using:

• AVERAGE has a maximum of 256 arguments, which can be numbers, names, ranges or cell references containing numbers.
• The cell reference parameter or range contains a logical, text, or empty value, the function is automatically omitted, the value 0 alone will be calculated.
• Logical values, denoting the text as numbers when entering directly into the list of arguments in the function will be counted.
• If the argument is text or the value cannot be converted to a numeric form, an error will occur.

We will take the example with the data table below, averaging the scores for each student.

Step 1:

In the first average score box for the first student, the user enters the formula = AVERAGE (C2, D2, E2) and then press Enter.

Step 2:

The result will be displayed as shown below. In the case of decimal results as shown and want to round, the reader should refer to the article How to round numbers in Excel.

To calculate the average of the next cells, users simply point to the first result box and drag down the cells below.

2. Fix #VALUE Error Using Average Function

While using the Average function to calculate the average of data on Excel, users will encounter some common errors such as reporting the #VALUE! Error. This error occurs when the argument in the calculation that the Average function cannot interpret those values ??is a numeric value.

With the image below, cell F2 is reporting a #VALUE! Error. Because in the calculation, cell E2 contains the #VALUE value.

To fix the #VALUE! Error, you need to use two IF functions and the ISERROR function to ignore the reference area containing the error, to average the remaining normal values.

The function formula is = AVERAGE (IF (ISERROR (C2: E2), "", C2: E2)).

Since this is an array formula, users need to enter Ctrl + Shift + Enter to display the first and second brackets. If there are no parentheses the result will still report an error.

The result will be displayed as below. Cell E2 will not be included in the calculation.

Above is how to use the Average average function on Excel. The implementation is very simple, just need to localize the data you need to calculate. Also how to fix #VALUE! The above can be applied to # N / A, #NULL, # p / 0! Errors,. Of the Average function.

• How to use ConcateNate function on Excel
• How to use SUMPRODUCT function in Excel
• How to use the DAVERAGE function in Excel

I wish you all success!