# 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.