Category - Counting

List of user defined functions

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.
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 in a range.
COUNTVISIBLEA	*Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTVISIBLEIFS	Returns the number of visible, non blank cells that satisfies multiple conditions.

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.
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 in a range.
COUNTVISIBLEA *Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTVISIBLEIFS Returns the number of visible, non blank cells that satisfies multiple conditions.