AVERAGE Function in Excel

What is the AVERAGE function in Excel?

→ The Microsoft Excel AVERAGE function is used to make an average or calculate simple arithmetic mean of numbers in a range of cells.

→ The AVERAGE function is a built-in function in Excel.

→ This function is a worksheet function in Excel.

→ We need to enter this function as a formula in the cell.

→ The AVERAGE function returns a numeric value.

→ We can put the AVERAGE function in the Statistical Function Category

→ Refer below tutorial for easily understand how to use the Excel AVERAGE function with syntax and examples.

→ We can easily use this function just adding the formula in the spreadsheet.

→ The syntax for the AVERAGE function in Microsoft Excel is:

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

=AVERAGE(cell1:cell2, [cell3:cell4], ... )

➨ Note: By using the AVERAGE function, also you can get a sum of cell range and numbers together. As mentioned below.

=AVERAGE(number1, [number2, …], cell1:cell2, [cell3:cell4], …)

→ We will take a different four types of Example of an average function for better understanding.

→ Excel spreadsheet with formulas results is mentioned below.

Example 1: AVERAGE of multiple cells

=AVERAGE(A2,A3,A4)

Result = 22.33

Example 2: Average of multiple cells and numbers

=AVERAGE(A2,B3,25)

Result = 15.50

Example 3: Average of multiple cell ranges

=AVERAGE(A2:A4,B2:B4)

Result = 14.08

Example 4: Average of multiple cells, cell ranges, and numbers

=AVERAGE(A2:A6,B2,B3,25)

Result = 15.13

➨ Join us (Telegram Channel)

➨ Join us (LinkedIn Page)