MS-Excel (Numeric Functions)

NUMERICAL FUNCTIONS IN EXCEL

Sum: This function is used to calculate the sum of all selected values. 

Example:  =Sum(A1:A10)

Average: This function is used to calculate the average of all selected values.

Example:  =Average(A1:A10)

Min: This function is used to find the smallest value among all selected values.

Example:  =Min(A1:A10)

Max: This function is used to find the largest value among all selected values.

Example:  =Max(A1:A10)

Count: This function is used to only count all selected numerical values.

Example:  =Count(A1:A10)

Counta: This function is used to count both values (Text & Number)

Example:  =CountA(A1:A10)

CountBlank: This function is used to count only blank cells.

Example:  =CountBlank(A1:A10)

CountIf: This function is used to count a particular or numerical value or text value according to a given condition.

Example 1: =Countif(A1:A10,"XII")

Explanation: This function is used to count total text "XII" from A1 to A10 cells.

Example 2: =Countif(A1:A10,">50")
Explanation: This function is used to count all values, those are greater than 50.

SumIf: This function is used to calculate only selected numerical values by a certain condition.

Example: Sumif(A1:A10,">75")
Explanation: This function is used to calculate the sum of all values which are greater than 70.

HOME