Excel AVERAGE Function and Formula with Examples


How to Use the AVERAGE Function and Formula in Excel

In this tutorial, you'll learn how to use the AVERAGE function and formula in Excel. 

AVERAGE() calculates the average of a group of numbers.

AVERAGE Syntax

The syntax of the AVERAGE() function is as follows:

=AVERAGE (number1, [number2], ...)

Arguments

  • number1: The first number, ranges, or cell reference
  • number2: Optional. Numbers, cell references, or ranges.

Remarks

  • number1number2,.. can be numbers, ranges, names, or cell references that contain numeric values.
  • You can specify the additional arguments up to 255.

Excel AVERAGE Function Examples

Demo data:

 ABCDEF
1DateCodeItem NameQuantityPrice ($)Amount ($)
210/5/2019Item022Desktop PC 223225675
310/5/2019Item011Desktop PC 1127501500
410/5/2019Item033Desktop PC 331235235
510/6/2019Item022Desktop PC 2237852355
610/6/2019Item011Desktop PC 11310503150
710/8/2019Item033Desktop PC 331275275
810/9/2019Item022Desktop PC 2242901160

Finding an average of a group of numbers 

The following example returns the average of a group of 5 numbers:

=AVERAGE(200, 100, 400, 300, 600)

AVERAGE() finds an average of numbers 200, 100, 400, 300, and 600 and returns 320.

Finding an average of numbers in a range of cells

The following example returns the average of numbers in a range of cells:

=AVERAGE(F2:F8)

The above formula returns 1335.714.

Finding an average of numbers in a range of cells and the additional cell

Here is an example:

=AVERAGE(F2:F7,F8)

The above formula returns 1335.714.

Finding an average of numbers in a range of cells, a cell, and the other three numbers

Here is an example:

=AVERAGE(F2:F7,F8,150,200,400)

The above formula returns 1010.

In this tutorial, you've learned how to use the Excel AVERAGE function.

AVERAGE is a function to find an average of a group of numbers.

Leave a Reply

Your email address will not be published. Required fields are marked *