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.