Excel AVERAGE() Function
Excel AVERAGE() Function
The AVERAGE() function returns the average of its arguments, which can be number or names, arrays, or references that contain numbers. It ignores text values and blank cells.
Syntax
AVERAGE(Number1,Number2, ...)
Parameter
Number1(required)- This parameter represents the string for which you want to find the length.
Number2, …(optional)- It represents the list of values from which you want to find the average value.
Category
Statistical
Returns
This function returns the average value of the given numbers.
Example 1
Objective: Use AVERAGE function to find the smallest value of the 3 numbers present for each row
| Number1 | Number2 | Number3 | Result | Formula |
| 3 | 5 | 4 | =AVERAGE (A1:C1) | |
| 19 | A | 1 | 10 | =AVERAGE(A2:C2) |
| 8 | b | c | 8 | =AVERAGE(A3:C3) |
| -8.5 | 3 | 0.5 | -1.666666667 | =AVERAGE(A4:C4) |
Example 2
| Emp_ID | Employee Name | DOJ | Deployed City/State | Department | Monthly Salary |
| E001 | Phebe Bhuffay | 12/11/2011 | Hyderabad | Accounts | $150,000 |
| E002 | Jacky Bling | 08/09/2012 | Gujarat | Finance | $115,550 |
| E003 | Rachel Green | 01/02/2009 | Noida | Marketing | $99,500 |
| E004 | Sadhan Kumar | 01/04/2013 | Gurugram | Customer Support Executive | $35,000 |
Objective: Get the average salary per employee
| Result | Formula Text |
| $98,888 | =AVERAGE(A2:A5) |