What does it do?

Gives you the average of a group of values

Formula breakdown:

=AVERAGE(number1, number2…)

What it means:

=AVERAGE(the numbers you want to average)


 

There are times when you have to get the average of your values in your Excel worksheet and you would normally have to SUM all of the values then divide it by the number of values.

That’s the long process!

Thankfully there is a quicker way with Excel’s AVERAGE formula!

In our example below, we have the table of values that we need to get the average from:

Average of Values with Excel

I explain how you can do this below:

DOWNLOAD EXCEL WORKBOOK

STEP 1: We need to enter the AVERAGE  function in a blank cell:

=AVERAGE(

Average of Values with Excel

 

STEP 2: The AVERAGE arguments:

text

What numbers do we want to get the average of?

Select the range of values:

=AVERAGE(D9:D12)

Average of Values with Excel

 

You have now calculated the average of the Sales numbers!

Average of Values with Excel

Get the Average of Values with Excel’s AVERAGE Formula

Average of Values with Excel

HELPFUL RESOURCE:

oztraining_728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

CountBlank Formula in Excel What does it do? Counts the number of cells that are blank Formula breakdown: =COUNTBLANK(range) What it means: =COUNTBLANK(range of cells to check) Do you have a scenario where you want to count the number of cells that are blank in your Excel data? If y...
Calculate the Compound Interest with Excel’s... What does it do? Calculates the compound interest Formula breakdown: =FV(rate, nper, pmt, ) What it means: =FV(interest rate, number of periods, periodic payment, initial amount) Say that you turn 18 years today (CONGRATS!) and you find out that your parents...
Extracting Data with Excel’s LEFT Formula What does it do? It returns the first character or characters in a text string, based on the number of characters you specify. Formula breakdown: =LEFT(text, ) What it means: =LEFT(look in this cell, extract X characters) There are times when you will need t...
Cleaning Data with Excel’s PROPER Formula   What does it do? Capitalizes the first letter in a text string and any other letters in the text that follow a space. Converts all other letters to lowercase letters. Formula breakdown: =PROPER(text) What it means: =PROPER(this text cell) There are...