Counting Functions

List of user defined functions

COUNTFORMATReturns the number of cells that have been formatted with a particular colour.
COUNTFORMAT_CELLCOLOR 
COUNTFORMAT_FONTBOLD 
COUNTFORMAT_FONTCOLOR 
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.
COUNTVISIBLEReturns the number of visible non blank cells.
COUNTIFVISIBLEReturns the number of visible non blank cells that satisfies one condition.
COUNTIFSVISIBLEReturns the number of visible non blank cells that satisfies multiple conditions.
WORKSHEETSCOUNTReturns 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.

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