COUNT
Excel COUNT function provides count of values that are numbers. Numbers include negative, positive, times, dates, fractions, percentages, and formulas that return numbers.
Syntex
=COUNT (value1, [value2], ...)
Arguments
value1 - An item, cell reference, or range.
value2 - [optional] An item, cell reference, or range.
COUNTA
Excel COUNTA function provides count cells that contain number, text, formula, errors and non-empty cells. COUNTS does not count blank cells.
Syntex
=COUNTA (value1, [value2], ...)
Arguments
value1 - An item, cell reference, or range.
value2 - [optional] An item, cell reference, or range.
COUNTBLANK
Excel COUNTBLANK function provides count of cell that is blank
Syntax
=COUNTBLANK (range)
Arguments
range– Selection of input
COUNTIF
COUNTIF function provides count of cells that meets the given criteria. Criteria supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.
Syntax
=COUNTIF (range, criteria)
Arguments
range - The range of cells to count.
criteria - The criteria that controls which cells should be counted.
COUNTIFS
COUNTIFS function provide count of cells that meets the one or more criteria.
Syntax
=COUNTIFS (range1, criteria1, [range2], [criteria2], ...)
Arguments
range1 - The first range
criteria1 - The criteria to use on range1.
range2 - [optional] The second range.
criteria2 - [optional] The criteria to use on range2.
COUNTIFS will provide only those counts of cells that met the all criteria in given range.
