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

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin