Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

AVERAGEIF Formula

The AVERAGEIF formula returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria in the parameter. It works with single criteria only. 

Syntax of AVERAGEIF formula

AVERAGEIF( range, criteria, [average_range] )

Parameters details:

range : The range of cells that you want to apply the criteria against.

criteria : The criteria used to determine which cells to average.

average_range : Optional. It is the cells to average. If average_range is omitted, it uses range as the value for this parameter.

Returns

The AVERAGEIF function returns a numeric value.