Math Functions

Sumif()

The SUMIF function calculates the total of only those cells that meet a given condition or criteria. The syntax for the SUMIF function is : =SUMIF(Range,Criteria,Sum Range)

-> Range is the range of the cells that are to be evaluated by the function.

-> A Criterion is the condition or criteria the cells are to match if it is to be included in the sum. The criteria can be a number, expression, or text.

Statistical Function

Count()

This function counts the number of numeric entries in a list. It will ignore blanks, text, and errors. The syntax of this function is: =COUNT(Range 1, Range2, Range3…. through to Range30)

Example:

The following figure evaluates the use of Count function

Countif ()

The count if function counts the number of cells in a given range that meet a specific condition. The syntax of the function is: =COUNTIf(Range, Criteria)

The range is used to declare a group of cells from which you want to count those cells, which meet the criteria. Criteria are used to declare the searching matter, it can be a number as well as a value.

Example :

The criteria can be typed in any of the following ways.

• To match a specific number type the number, such as =COUNTIF(A1:A5,100)

• To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,”Hello”)

• To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5,”>100”)

Countblank ()

The countblannk function return, how many cells are blank within a specified range. The syntax of the function is =COUNTBLANK(Range to test).