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