Financial		Logical		Informational		Text
Mathematical		Statistical		Lookup		Reference		Formula Errors

COUNT formula counts the numbers in a given range and excludes #error values , text and blanks

Syntax
COUNT(value1, [value2],...)

value1 A Value or cell reference or range of cells
value2 A Value or cell reference or range of cells

COUNTA formula counts the number of Text cells in a range and excludes empty cells

Syntax
COUNTA(value1, [value2], ...)

value1 A Value or cell reference or range of cells
value2 A Value or cell reference or range of cells

The COUNTIF function counts the number of cells within a range that meet a single criterion that you specify.

Syntax
COUNTIF(range, criteria)

COUNTIFS formula applies criteria across multiple ranges and counts the number of records that meet all criteria
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)


criteria_range1 Range where the criteria is applied
criteria1 An Expression that defines which cells will be evaluated. Examples... 350, ">100", A2 or "Cars"
criteria_range2, criteria2, Pair of Additional ranges and criteria

SUM function adds all the numbers that you specify as arguments. Each argument can be a range, a cell reference, an array, a constant, a formula, or the result from another function.
Example
SUM(A1:A5)
SUM(A1, A3, A5)

Syntax SUM(number1, [number2], [number3], [number4], ...)

SUMIF function is used to sum the values in a range that meet the criteria you specify.

Syntax
SUMIF(range, criteria, [sum_range])

range The range of cells that you want evaluated by criteria.
criteria An Expression that defines which cells will be evaluated. Examples... 350, ">100", A2 or "Cars"
sum_range The range of cells to add, if this optional argument is omitted then cell reference in range is added

Note:If the criteria is numeric, double quotation marks are not required. Note: Any text criteria or any criteria that includes logical or mathematical symbols must be enclosed in double quotation marks (").

SUMIFS sums the cells in a range that meet multiple criteria.

Warning The order of arguments differ between the SUMIFS and SUMIF functions.

Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2,criteria2], …)


sum_range One or more cells to sum, including numbers or names, ranges, or cell references that contain numbers. Blank and text values are ignored.

criteria_range1 The first range in which to evaluate the associated criteria.

criteria1 The criteria in the form of a number, expression, cell reference, or text that define which cells in the criteria_range1 argument will be added. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32."

criteria_range2, criteria2 Additional ranges and their associated criteria.

Click Here to Download a copy of ExcelTechie Mathematical Formulas Workbook