Excel Average Function / Average of a group of numbers

Channel:

SL Data Hub

Subscribers:

512

Published on September 29, 2021 2:23:25 PM ● Video Link: https://www.youtube.com/watch?v=kFxlKhlvr1Y

Duration: 3:18

7 views

0

The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.

Purpose
Get the average of a group of numbers

Return value
A number representing the average.
Syntax
=AVERAGE (number1, [number2], ...)

Arguments
number1 - A number or cell reference that refers to numeric values.
number2 - [optional] A number or cell reference that refers to numeric values.

Usage notes
The AVERAGE function calculates the average of numbers provided as arguments. To calculate the average, Excel sums all numeric values and divides by the count of numeric values.

AVERAGE takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can include numbers, cell references, ranges, arrays, and constants. Empty cells, and cells that contain text or logical values are ignored. However, zero (0) values are included. You can ignore zero (0) values with the AVERAGEIFS function, as explained below.

The AVERAGE function will ignore logical values and numbers entered as text. If you need to include these values in the average, see the AVERAGEA function.

SL Data Hub Facebook Page - https://www.facebook.com/SL-Data-Hub-109653178145244/