Category - Counting

List of user defined functions

COUNTAVISIBLE	Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEEN	Returns the number of cells that have a value that is between a range.
COUNTFORMAT	Returns the number of cells that have been formatted with a particular cell colour or font colour.
COUNTFORMAT_CELLCOLOR	Returns the number of cells that have been formatted with a particular colour.
COUNTFORMAT_FONTBOLD	Returns the number of cells that have been formatted in bold.
COUNTFORMAT_FONTCOLOR	Returns the number of cells that have been formatted with a particular font colour.
COUNTHIDDENSHEETS	Returns the number of hidden worksheets in the active workbook.
COUNTSHEETS	Returns the total number of worksheets and chart sheets in the active workbook.
COUNTSUBSTRING	Returns the number of times a substring occurs in a longer string.
COUNTTEXTCELLS	Returns the number of cells that contain text.
COUNTVISIBLE	Returns the number of visible non blank cells.
COUNTVISIBLEIFS	Returns the number of visible non blank cells that satisfies multiple conditions.

COUNTAVISIBLE Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEEN Returns the number of cells that have a value that is between a range.
COUNTFORMAT Returns the number of cells that have been formatted with a particular cell colour or font colour.
COUNTFORMAT_CELLCOLOR Returns the number of cells that have been formatted with a particular colour.
COUNTFORMAT_FONTBOLD Returns the number of cells that have been formatted in bold.
COUNTFORMAT_FONTCOLOR Returns the number of cells that have been formatted with a particular font colour.
COUNTHIDDENSHEETS Returns the number of hidden worksheets in the active workbook.
COUNTSHEETS Returns the total number of worksheets and chart sheets in the active workbook.
COUNTSUBSTRING Returns the number of times a substring occurs in a longer string.
COUNTTEXTCELLS Returns the number of cells that contain text.
COUNTVISIBLE Returns the number of visible non blank cells.
COUNTVISIBLEIFS Returns the number of visible non blank cells that satisfies multiple conditions.