EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Excel Average Formula

By Ashwani JaiswalAshwani Jaiswal

Home » Excel » Blog » Statistical Functions in Excel » Excel Average Formula

Average formula in Excel

Excel Average Formula (Table of Contents)

  • Average Formula in Excel
  • How To Use Average Formula in Excel?

Average Formula in Excel

The average formula in excel simply gives the average of selected numeric cell values. Average means if we take out the sum of some values and divide that with calculated sum with the total number of iterations, gives the average of all the values.

Start Your Free Excel Course

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

How To Use Average Formula in Excel?

In our school days, we calculated the average of any range by summing the values first, then dividing the same with the total number of values used in the sum. But in excel, we have a simple formula for calculating an average. For this, from the Insert Function option in excel, we can search AVERAGE to use it.

Average formula 1

Or else go to edit mode of any cell by typing = (equal sign) and then select an average function from it as shown below.

Average formula 2

Average Formula in Excel – Example #1

Let’s understand How to use the Average Formula in Excel with some examples.

You can download this Average Formula Excel Template here – Average Formula Excel Template

We have sample data of the sale of a product of 10 days, as shown below.

Average formula example 1-1

Now let’s calculate the average sales of given data. For this, go to the cell where we want to apply the average formula to see the result and then click on the Insert Function icon just beside the Formula bar in excel, as shown below.

Popular Course in this category
Excel Advanced Training (14 Courses, 23+ Projects)14 Online Courses | 23 Hands-on Projects | 133+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (7,136 ratings)
Course Price

View Course

Related Courses
Excel for Marketing Training (5 Courses, 13+ Projects)

Average formula example 1-2

Or Go to Formulas Tab and Select Insert Function, as shown below.

Average formula example 1-3

After that, we will get an Insert Function box, as shown below. From there, search for the Average function and then click OK. We can also locate the Average function in the Statistical functions category from Or select a category box.

Average formula example 1-4

As we can see above, after selecting the function, we will get the syntax suggestion also, which is highlighted in the box.

Once we click on OK, it will take us to the Average Function Argument window. There, select the cells or range for which we need to find the average. Here we can select more than 1 range in a different number of cells. After that, click on, OK.

Average formula example 1-5

As we can see, we got the average of the selected range as 33.6 for the selected range B2 to B11.

Average formula example 1-6

Many people already notice this; the same result will be visible at the bottom of the excel sheet, as shown below. We can see the total selected cells, the sum of all the numbers and the average of the selected numbers.

 Example 1-7

Average Formula in Excel – Example #2

This is another way to take an average.  We will consider the same data which we have seen above for taking an average. This is a simple and quick way to get the required result. For this, go to the cell where we want to see the output. Now type = (Equal sign) to go in edit mode of that selected cell. Now type AVERAGE and select the exact function, as shown below.

Average formula example 2-1

As we can see, the syntax of the selected function is also seen. We see work as per that as well. To complete the syntax, select the range of cells for which we need to calculate the average.

Here we have selected the range from cell B2 to B11 cell, as shown below.

Example 2-2

And then press Enter to get the result. As we can see, the average of selected cells is 33.6, as shown below.

Example 2-3

We can also check at the bottom of the excel sheet, whether showing the same average. For this, select the cells and go down.

Example 2-4

As we can see above, it shows the same average as 33.6 for selected cell count 10. This proofs the exactness of the formula we used.

Average Formula in Excel – Example #3

We can get more precise results if we use AVERAGE with ROUND. This will give the round figure result instead of a figure with decimal digits. For this, Add the ROUND function once we apply the AVERAGE. Press = in any cell and search and select the ROUND function. Here we can see the syntax of ROUND as shown below.

Round Formula Syntax

It says number and num_digits are part of the syntax. Now for number, apply the AVERAGE Formula, and for num_digits, select as shown below.

Example 3-1

This will give us the average of the selected range without any decimal digit count. The result will be in the whole number.

Example 3-2

Things to Remember

  • Always select the complete range. If there are blank cells in between, select the cell as well to fill the gap.
  • We can get the result in round figures by using the ROUND function before AVERAGE, as explained in example, -3.
  • The AVERAGE function can be used vertically, horizontally or in any matrix-shaped data in any form.

Recommended Articles

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

  1. Excel AVERAGEIF
  2. Excel AVERAGE Function
  3. Excel Moving Averages
  4. Weighted Average in Excel

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Statistical Functions in Excel
    • COUNTIF Formula in Excel
    • 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 (110+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (13+)
  • Lookup Reference Functions in Excel (33+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (25+)
  • Date and Time Function in Excel (22+)
  • Information Functions in Excel (4+)
  • Excel Charts (55+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (20+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training Certification
  • Online Excel for Marketing Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • 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

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

EDUCBA Login

Forgot Password?

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
Book Your One Instructor : One Learner Free Class

Let’s Get Started

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

EDUCBA

Download Average Formula Excel Template

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
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

Special Offer - EXCEL ADVANCED Training Certification Learn More