Category - Counting

List of user defined functions

COUNTAVISIBLEReturns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEENReturns the number of cells that have a value that is between a range.
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.
COUNTHIDDENSHEETSReturns the number of hidden worksheets in the active workbook.
COUNTSHEETSReturns the total number of worksheets and chart sheets in the active workbook.
COUNTSUBSTRINGReturns the number of times a substring occurs in a longer string.
COUNTTEXTCELLSReturns the number of cells that contain text.
COUNTVISIBLEReturns the number of visible non blank cells.
COUNTVISIBLEIFSReturns the number of visible non blank cells that satisfies multiple conditions.
COUNTAVISIBLE
Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEEN
Returns the number of cells that have a value that is between a range.
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.
COUNTHIDDENSHEETS
Returns the number of hidden worksheets in the active workbook.
COUNTSHEETS
Returns the total number of worksheets and chart sheets in the active workbook.
COUNTSUBSTRING
Returns the number of times a substring occurs in a longer string.
COUNTTEXTCELLS
Returns the number of cells that contain text.
COUNTVISIBLE
Returns the number of visible non blank cells.
COUNTVISIBLEIFS
Returns the number of visible non blank cells that satisfies multiple conditions.

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