
Statistic Function
Average: This function returns the average of number series
Syntax = AVERAGE(number1, [number2],..)
Example

2.1) Count: This function count the number between range that contain numbers
Syntax = COUNT(value1, [value2],..)
Example

2.2) Counta: This function count the logical value, text and error values.
Syntax = COUNTA(value1, [value2],..)
Example

2.3) Countif: This function count only particular criteria from cell range.
Syntax = COUNTIF(range, criteria)
Example


2.4) Max: This function returns the largest value of number series
Syntax = MAX(number1, [number2],..)
Example

2.5) Min: This function returns the smallest value of number series
Syntax = MIN(number1, [number2],..)
Example

2.6) Large: This function returns the k-th largest value of number series
Syntax = LARGE(array, k)
Example

2.7) Small: This function returns the k-th smallest value of number series
Syntax = SMALL(array, k)
Example
