Excel Functions Counting Functions

List of user defined functions

COUNTFORMAT	Returns the number of cells that have been formatted with a particular colour.
COUNTFORMAT_CELLCOLOR
COUNTFORMAT_FONTBOLD
COUNTFORMAT_FONTCOLOR
COUNTNUMBEROFDAYS	Returns the number of days in a month and/or year.
COUNTTEXTCELLS	Returns the number of cells that contain text.
COUNTSUBSTRING	Returns the number of times a substring occurs in a longer string.
COUNTVISIBLE	Returns the number of visible non blank cells.
COUNTIFVISIBLE	Returns the number of visible non blank cells that satisfies one condition.
COUNTIFSVISIBLE	Returns the number of visible non blank cells that satisfies multiple conditions.
WORKSHEETSCOUNT	Returns the total number of sheets in the active workbook.

COUNTFORMAT Returns the number of cells that have been formatted with a particular colour.
COUNTFORMAT_CELLCOLOR
COUNTFORMAT_FONTBOLD
COUNTFORMAT_FONTCOLOR
COUNTNUMBEROFDAYS Returns the number of days in a month and/or year.
COUNTTEXTCELLS Returns the number of cells that contain text.
COUNTSUBSTRING Returns the number of times a substring occurs in a longer string.
COUNTVISIBLE Returns the number of visible non blank cells.
COUNTIFVISIBLE Returns the number of visible non blank cells that satisfies one condition.
COUNTIFSVISIBLE Returns the number of visible non blank cells that satisfies multiple conditions.
WORKSHEETSCOUNT Returns the total number of sheets in the active workbook.