Counting Functions


Worksheet Functions

COUNTReturns the number of non blank cells in a list, table or cell range.
COUNTAReturns the number of non blank cells in a list, table or cell range (including logical values and text).
COUNTBLANKReturns the number of blank cells in a list, table or cell range.
COUNTIFReturns the number of non blank cells that satisfies one condition. You can achieve the same results by combining the SUM function with array formulas.
COUNTIFSReturns the number of non blank cells that satisfies multiple conditions.
DCOUNTReturns the total number of non blank cells in a database column satisfying certain conditions.
AGGREGATEReturns the aggregate of values in a list, table or cell range.
SUBTOTALReturns the subtotal of values in a list, table or cell range.
SUMPRODUCTReturns the sum of the product of one or more arrays of values.
COUNT
Returns the number of non blank cells in a list, table or cell range.
COUNTA
Returns the number of non blank cells in a list, table or cell range (including logical values and text).
COUNTBLANK
Returns the number of blank cells in a list, table or cell range.
COUNTIF
Returns the number of non blank cells that satisfies one condition. You can achieve the same results by combining the SUM function with array formulas.
COUNTIFS
Returns the number of non blank cells that satisfies multiple conditions.
DCOUNT
Returns the total number of non blank cells in a database column satisfying certain conditions.
AGGREGATE
Returns the aggregate of values in a list, table or cell range.
SUBTOTAL
Returns the subtotal of values in a list, table or cell range.
SUMPRODUCT
Returns the sum of the product of one or more arrays of values.

Conditional Counting

COUNTIFUsing the COUNTIF function with multiple conditions.
COUNTIFSUsing the COUNTIFS function with multiple conditions.
SUMPRODUCTUsing the SUMPRODUCT function with multiple conditions.
COUNTIF
Using the COUNTIF function with multiple conditions.
COUNTIFS
Using the COUNTIFS function with multiple conditions.
SUMPRODUCT
Using the SUMPRODUCT function with multiple conditions.

User Defined Functions

COUNTFORMATReturns the number of cells that have been formatted with multiple attributes.
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.
COUNTFORMAT_CELLCOLORReturns the number of cells that have been formatted with a particular colour.
COUNTTEXTCELLSReturns the number of cells that contain text.
COUNTSUBSTRINGReturns the number of
COUNTVISIBLEReturns the number of visible non blank cells.
COUNTVISIBLEIFSReturns the number of visible non blank cells that satisfies multiple conditions.
COUNTFORMAT
Returns the number of cells that have been formatted with multiple attributes.
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.
COUNTFORMAT_CELLCOLOR
Returns the number of cells that have been formatted with a particular colour.
COUNTTEXTCELLS
Returns the number of cells that contain text.
COUNTSUBSTRING
Returns the number of
COUNTVISIBLE
Returns the number of visible non blank cells.
COUNTVISIBLEIFS
Returns the number of visible non blank cells that satisfies multiple conditions.

More Counting Formulas

Counting Formulas contains a list of all counting relating formulas.



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