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:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

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

Change Phone Area Codes with Excel’s REPLACE Formu... What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the ...
VLOOKUP with Multiple Criteria in Excel ‘VLOOKUP’ is now so common that everyone who has ever been working with Excel has heard of it. Not necessarily because they know how to use it, but because some savvy Excel-user always talks about it at the office. Advanced users have seen the use of adding more than one...
Cleaning Data with Excel’s REPLACE Formula What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the ...
Extract First Name From Full Name in Excel There were countless times when I had a list of full names, and all I needed was the First Name. It would be time-consuming to manually get the first names one by one. Thank goodness there are formulas to make my life easier! In Excel, it's very easy to do that with the LEFT a...