How do I use AVERAGE in Excel?
Use AVERAGE when you want to calculate an average. Enter Target range, Additional range in that order, then add optional arguments when needed.
Excel Function
AVERAGE
Returns the arithmetic mean.
AVERAGE(number1, [number2], ...)Arguments
number1
RequiredSpecify the first number or range to calculate.
number2
OptionalOptional second argument; leave blank when not needed.
Practice Preview
Use AVERAGE to calculate the average of Sales in column D. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | 980 |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | 300 |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=AVERAGE(D2:D8)Result
791.428571
Practice This Function
AVERAGE FAQ
Where can I practice AVERAGE?
Use the "Start Function Practice" button to jump straight into AVERAGE drills.
What arguments does AVERAGE use?
The main arguments are Target range, Additional range. Start with the required ones, then add optional arguments if needed.