MS Excel Learning Classes – 8

SUMIF

Adds the cells specified by a given criteria.

Syntax                                SUMIF(range,criteria,sum_range)

Range                  is the range of cells you want evaluated.

Criteria                is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, “32”, “>32”, “apples”.

Sum_range       are the actual cells to sum.

Example

MAX

Returns the largest value in a set of values.    Syntax                                MAX(number1,number2,…)

Number1, number2, …    are 1 to 30 numbers for which you want to find the maximum value.

Example

MIN

Syntax                    MIN(number1,number2,…)Returns the smallest number in a set of values.

Number1, number2, …    are 1 to 30 numbers for which you want to find the minimum value.

Example

MOD

Syntax                MOD(number,divisor)Returns the remainder after number is divided by divisor. The result has the same sign as divisor.

Number    is the number for which you want to find the remainder.

Divisor    is the number by which you want to divide number.

Example

COUNTIF

Counts the number of cells within a range that meet the given criteria.

Syntax                  COUNTIF(range,criteria)

Range    is the range of cells from which you want to count cells.

Criteria    is the criteria in the form of a number, expression, or text that defines which cells will be counted.

Example

NOW

Syntax                  NOW( )Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date.

PRODUCT

Multiplies all the numbers given as arguments and returns the product.

Syntax                  PRODUCT(number1,number2,…)

Number1, number2, …    are 1 to 30 numbers that you want to multiply.

Example