Pinterest Pixel

Get the Average of Values with Excel’s AVERAGE Formula

What does it do? Gives you the average of a group of values Formula breakdown: =AVERAGE(number1, number2…)... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

Get the Average of Values with Excel's AVERAGE Formula | MyExcelOnline Get the Average of Values with Excel's AVERAGE Formula | MyExcelOnline

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:

Get the Average of Values with Excel's AVERAGE Formula

I explain how you can do this below:

Get the Average of Values with Excel's AVERAGE Formula | MyExcelOnline

Download excel workbookAVERAGE-FORMULA.xlsx

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

=AVERAGE(

Get the Average of Values with Excel's AVERAGE Formula

 

STEP 2: The AVERAGE arguments:

Table of Contents

text

What numbers do we want to get the average of?

Select the range of values:

=AVERAGE(D9:D12)

Get the Average of Values with Excel's AVERAGE Formula

 

See also  HLOOKUP Function in Excel: Introduction

You have now calculated the average of the Sales numbers!

Get the Average of Values with Excel's AVERAGE Formula

Get the Average of Values with Excel’s AVERAGE Formula

 

 

If you like this Excel tip, please share it
Get the Average of Values with Excel's AVERAGE Formula | MyExcelOnline Get the Average of Values with Excel's AVERAGE Formula | MyExcelOnline
Get the Average of Values with Excel's AVERAGE Formula | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...