Statistical Functions in Excel

1. AVERAGE Function

Returns the average of numeric values.

Syntax

=AVERAGE(number1,number2,…)

Arguments

  • number1: The first number that you want to use for the average calculation.
  • [number2]: The second number that you want to use for the average calculation.

2. AVERAGEA Function

Returns the average of values.

Syntax

=AVERAGEA(value1,value2,…)

Arguments

  • value1: A value which is a number, a logical value or a number that is stored as a text.
  • [value2]: A value which is a number, a logical value or a number that is stored as a text.

3. AVERAGEIF Function

Returns the average based on a condition.

Syntax

= AVERAGEIF(range, criteria, average_range)

Arguments

  • range: A range that contains values from which you want to check the condition.
  • criteria_range: A range of cells from which you want to test the condition.
  • criteria: A condition that you want to mention.

AVERAGEIFS

Returns the average based on multiple conditions.

Syntax

= AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Arguments

  • criteria_range1: A range of cells from which you want to test the condition.
  • criteria1: A condition that you want to test.
  • [criteria_range2]: The second range of cells from which you want to test the condition.
  • [criteria1]: A second condition that you want to test.

4. COUNT Function

Returns the count of numbers.

Syntax

= COUNT(value1, [value2], …)

Arguments

  • value1: A cell reference, an array or a number that is directly entered into the function.
  • [value2]: A cell reference, an array or a number that is directly entered into the function.

5. COUNTA Function

Returns the count of non-blank cells.

Syntax

= COUNTA(value1, [value2], …)

Arguments

  • value1: A value, a cell reference, a range of cells, or an array.
  • [value2]: A value, a cell reference, a range of cells, or an array

COUNTBLANK

Returns the count of the number of empty cells.

Syntax

= COUNTBLANK(range)

Arguments

  • range: A range of cells from which you want to count blank cells.

COUNTIF

Returns the count based on a condition.

Syntax

= COUNTIF(range, criteria)

Arguments

  • range: A range of cells from which you want to count the cells which meet criteria.
  • criteria: A criteria (Case Sensitive) to check to count cells.

COUNTIFS

Returns the count based on multiple conditions.

Syntax

= COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Arguments

  • criteria_range1: The range of cells that you want to evaluate using criteria1.
  • criteria1: The criteria which you want to evaluate for criteria_range1.
  • [criteria_range2]: The range of cells that you want to evaluate using criteria1.
  • [criteria2]: The criteria which you want to evaluate for criteria_range1.

MAX

Returns the maximum value.

Syntax

= MAX(number1, [number2], …)

Arguments

  • number1: A number, a cell that has a number or a range of cells having numbers from which you want to get the largest number.
  • [number2]: A number, a cell that has a number or a range of cells having numbers from which you want to get the largest number.

MIN

Returns the minimum value.

Syntax

= MIN(number1, [number2], …)

Arguments

  • number1: A number, a cell that has a number, or a range of cells having numbers from which you want to get the smallest number.
  • [number2]: A number, a cell that has a number, or a range of cells having numbers from which you want to get the smallest number.