Add Your Heading Text Here
Average
Count
Counta
Countif
Max
Min
Large
Small
Average
Average: This function returns the average of number series
Syntax = AVERAGE(number1, [number2],..)
Example
Count
2.1) Count: This function count the number between range that contain numbers
Syntax = COUNT(value1, [value2],..)
Example
Counta
2.2) Counta: This function count the logical value, text and error values.
Syntax = COUNTA(value1, [value2],..)
Example
Countif
2.3) Countif: This function count only particular criteria from cell range.
Syntax = COUNTIF(range, criteria)
Example
Max
2.4) Max: This function returns the largest value of number series
Syntax = MAX(number1, [number2],..)
Example
Min
2.5) Min: This function returns the smallest value of number series
Syntax = MIN(number1, [number2],..)
Example
Large
2.6) Large: This function returns the k-th largest value of number series
Syntax = LARGE(array, k)
Example
Small
2.7) Small: This function returns the k-th smallest value of number series
Syntax = SMALL(array, k)
Example