13 Sep
Summary of Excel count functions
COUNT
Counts the number of cells that contain numbers within a given range. It can also accept a list of arguments other than cell ranges and counts numbers within that list of arguments. Use COUNT to find out how many cells or arguments that have numeric values.
Syntax
COUNT(value1,value2,…)
COUNTA
Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.
Syntax
COUNTA(value1,value2,…)
COUNTBLANK
Counts empty cells in a specified range of cells.
Syntax
COUNTBLANK(range)
COUNTIF
Counts the number of cells within a range that meet the given criteria.
The criteria can be a number, text, expression or a cell reference.
Syntax
COUNTIF(range,criteria)
Applies to Excel 2003
