Excel Functions Category

List of user defined functions

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.
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.
COUNTIFSVISIBLE	Returns the number of visible non blank cells that satisfies multiple conditions.
COUNTVISIBLE	Returns the number of visible non blank cells.
WORKSHEETSCOUNT	Returns the total number of sheets in the active workbook.

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.
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.
COUNTIFSVISIBLE Returns the number of visible non blank cells that satisfies multiple conditions.
COUNTVISIBLE Returns the number of visible non blank cells.
WORKSHEETSCOUNT Returns the total number of sheets in the active workbook.