Counting Functions

List of user defined functions

COUNTFORMATReturns the number of cells that have been formatted with a particular cell colour or font colour.
COUNTFORMAT_CELLCOLORReturns the number of cells that have been formatted with a particular colour.
COUNTFORMAT_FONTBOLDReturns the number of cells that have been formatted in bold.
COUNTFORMAT_FONTCOLORReturns the number of cells that have been formatted with a particular font colour.
COUNTNUMBEROFDAYSReturns the number of days in a month and/or year.
COUNTTEXTCELLSReturns the number of cells that contain text.
COUNTSUBSTRINGReturns the number of times a substring occurs in a longer string.
COUNTIFSVISIBLEReturns the number of visible non blank cells that satisfies multiple conditions.
COUNTVISIBLEReturns the number of visible non blank cells.
WORKSHEETSCOUNTReturns 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.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext