Category - Counting
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. |
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext