EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Statistical Functions in Excel Excel AVERAGE Function
Secondary Sidebar
Excel Functions
  • Statistical Functions in Excel
    • COUNTIF Formula in Excel
    • COUNTIF Multiple Conditions
    • COUNTIFS with Multiple Criteria
    • Statistics in Excel
    • Confidence Interval in Excel
    • Interpolate in Excel
    • Linear Programming in Excel
    • COUNTIFS in Excel
    • Excel Variance
    • Normal Distribution Formula in Excel
    • Count Cells with Text in Excel
    • Excel Formula For Rank
    • Linear Regression in Excel
    • COUNTA Function in Excel
    • MAX Formula in Excel
    • Excel NORMSINV
    • Count Names in Excel
    • FORECAST Formula in Excel
    • NPER in Excel
    • Excel Median Formula
    • Lognormal Distribution in Excel
    • Excel Chi Square Test
    • Count Formula in Excel
    • COUNTIF Examples in Excel
    • Excel P-Value
    • COUNTIF Not Blank in Excel
    • Excel Standard Deviation Formula
    • Excel GROWTH Formula
    • Excel Percentile Formula
    • Excel Frequency Formula
    • Excel Average Formula
    • Excel Correlation Matrix
    • Excel Z Score
    • Excel MAX IF Function
    • Z TEST in Excel
    • Excel Trendline
    • Excel F-Test
    • Excel STDEV Function
    • Excel Frequency Distribution
    • DCOUNT Function in Excel
    • Excel MIN Function
    • Excel Forecast Function
    • FREQUENCY Excel Function
    • COUNTIF with Multiple Criteria
    • Standard Deviation in Excel
    • MAX Excel Function
    • Excel QUARTILE Function
    • Excel T.Test Function
    • Excel PERCENTILE Function
    • MODE Excel Function
    • SLOPE Excel Function
    • Excel Median Function
    • Excel TREND Function
    • Excel Count Function
    • Excel LARGE Function
    • SMALL Excel Function
    • COUNTIF Excel Function
    • Excel AVERAGE Function
    • Excel CORREL Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training Certification
  • Online Excel for Marketing Course

Excel AVERAGE Function

By Pradeep SPradeep S

AVERAGE in Excel

AVERAGE Function (Table of Contents)

  • AVERAGE in Excel
  • AVERAGE Formula in Excel
  • How To Use AVERAGE Function in Excel?

AVERAGE in Excel

The average function simply calculates the average of the selected numbers or digits in the same logic as we used to do in mathematics. The average function first calculates the sum of selected numbers and then divides the outcome from summation by the total numbers selected in the range. Thus, choosing the Average function overdoing the process to calculate the average is 2 fewer steps. Sometimes we have seen average to be called MEAN, but in excel, it will be available as AVERAGE.

AVERAGE function is categorized under Statistical functions. It is used as a worksheet & VBA function in excel.

AVERAGE steps

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

  • According to the mathematical definition, Arithmetic mean or Average is calculated by adding numbers together, then dividing the total by how many numbers are being averaged.
  • Its most commonly used function in a financial & statistical domain, where it will be helpful to analyze yearly average sales & revenue for a company
  • It is simple & easy to use Excel function with few arguments

Definition

AVERAGE: Calculate the arithmetic mean or average of a given set of arguments

AVERAGE Formula in Excel:

Below is the AVERAGE Formula:

The Formula or Syntax for an Average function is:

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,547 ratings)

AVERAGE formula

Where

Number1: Numeric values for which we want to find the average; the first argument is compulsory & it is required. subsequent arguments are optional, i.e. (from Number 2 onwards)

Arguments can be given as numbers or cell references, or ranges

Up to 255 numbers can be added

How to Use AVERAGE Function in Excel?

AVERAGE Function is very simple to use. Let us now see how to use the AVERAGE function in Excel with the help of some examples.

You can download this AVERAGE Function Excel Template here – AVERAGE Function Excel Template

Example #1

AVERAGE Calculation for a set of Numbers

With the help of the Average function, I need to find out an average of given numbers in the cell.

Let’s apply the Average function in cell “C12”. Select the cell “C12” where an Average function needs to be applied

AVERAGE Example 1-1

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “AVERAGE” in the search for a function box, an AVERAGE function will appear in select a function box. Double click on an AVERAGE function.

AVERAGE Example 1-2

A dialog box appears where arguments for the average function needs to be filled or entered, i.e. =Average (Number1, [Number 2]…). You can enter the numbers directly into the number arguments which are present in cells C8 TO C11.

AVERAGE Example 1-3

Click ok after entering all the numbers.

AVERAGE Example 1-4

i.e. =AVERAGE(8,5,7,4) returns 6 as the result.

AVERAGE Example 1-5

Example #2

To Calculate AVERAGE for Rows & Columns data

A) Average function for column range

In the below-mentioned example, the Table contains subject-wise marks or scores of a student in column C (C19 TO C24 is the column range)

With the help of the Average function, I need to find out the average score of a student in that column range (C19 TO C24 is the column range). Let’s apply the Average function in cell “C25”. Select the cell “C25” where an Average function needs to be applied.

AVERAGE Example 2-1

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “AVERAGE” in the search for a function box, an AVERAGE function will appear in the select a function box. Double click on an AVERAGE function

AVERAGE Example 2-2

A dialog box appears where arguments for the AVERAGE function needs to be filled or entered, i.e. =Average (Number1, [Number 2]…). Here, we need to enter the column range in the Number1 argument, click inside cell C19, and you’ll see the cell selected, then Select the cells till C24. So that column range will get selected, i.e. C19:C24. Click ok after entering the column range.

AVERAGE Example 2-3

i.e. =AVERAGE(C19:C24) returns 48.33333333 as the result.  The average subject score is 48.33333333

AVERAGE Example 2-4

B) Average function for row range

In the below-mentioned example, the Table contains subject-wise marks or score of a student in a row number 19, i.e. score or number row (F19 TO K19 is the row range)

AVERAGE Example 2-5

With the help of the Average function, I need to find out the average score of a student in that row range (F19 TO K19). Let’s apply the Average function in cell “L19”. First, select the cell “L19,” where an Average function needs to be applied.

average in excel Example 2-6

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “AVERAGE” in the search for a function box, an AVERAGE function will appear in select a function box. Double click on an AVERAGE function.

average in excel Example 2-7

A dialog box appears where arguments for the AVERAGE function need to be filled or entered, i.e. =Average (Number1, [Number 2]…).

Here, we need to enter the Number1 argument; so, click inside cell F19 and you’ll see the cell selected and then Select the cells until K19. So that row range will get selected, i.e. F19:K19. Click ok after entering the row range.

average in excel Example 2-8

i.e. =AVERAGE(F19:K19) returns 71 as the result.  The average subject score is 71

average in excel Example 2-9

Example #3

To Calculate AVERAGE Time

The average function helps out to calculate the average time that includes hours, minutes and seconds for a marathon race.

The below-mentioned table below contains the time data of the top three racers, i.e. Time taken by them to finish the race. (in hours, minutes and seconds format)

With the help of the average function, I need to find out the average time. Let’s apply the Average function in cell “I10”. Select the cell “I10”. where the Average function needs to be applied.

Average in excel Example 3-1

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “AVERAGE” in the search for a function box, an AVERAGE function will appear in select a function box. Double click on the AVERAGE function.

Average in excel Example 3-2

A dialog box appears where arguments for the AVERAGE function needs to be filled or entered, i.e. =Average (Number1, [Number 2]…).

Here, we need to enter the Number1 argument; so, click inside cell I7 and you’ll see the cell selected, then Select the cells till I9. So that column range will get selected, i.e. I7:I9. Click ok after entering the column range.

Average in excel Example 3-3

i.e. =AVERAGE(I7:I9) returns 1:44:21 as the result.  The average time value is 1:44:21

Average in excel Example 3-4

Things to Remember

  • Cells containing Boolean operators, text strings, TRUE, FALSE, and empty or blank cells will be ignored (Note: it will not ignore the cells with the value zero)
  • If any of the supplied arguments are entered directly, if they cannot be interpreted as numeric values, it gives #VALUE! error G. = AVERAGE (“Two”, “Five”, “Six”)
  • If any of the supplied argument is arguments are non-numeric, it gives #DIV/0! Error
  • The AVERAGE function differs from the AVERAGE A function, where an AVERAGE function is used to find an average of cells with any data, i.e. text values, numbers, and Boolean.
  • AVERAGE function is not restricted to find the average of a table range or row range or column range, or non-adjacent cells. Instead, you can specify individual cells in number arguments to get the desired results.

Recommended Articles

This has been a guide to the Excel AVERAGE function. Here we discuss the AVERAGE Formula and how to use an AVERAGE function in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Weighted Average in Excel
  2. Excel AVERAGEIF
  3. Excel Moving Averages
  4. Excel SUM MAX MIN AVERAGE
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for Marketing Training (8 Courses, 13+ Projects)4.9
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download AVERAGE Function Excel Template

EDUCBA

Download AVERAGE Function Excel Template

EDUCBA

डाउनलोड AVERAGE Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more