Counting Functions


Worksheet Functions

COUNTReturns the number of numerical values in a list, table or cell range.
COUNTAReturns the number of numerical values 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 numerical values that satisfies one condition.
COUNTIFSReturns the number of numerical values that satisfies multiple conditions.
AGGREGATEReturns the aggregate of values in a list, table or cell range.
DCOUNTReturns the total number of numerical values in a column that satisfies multiple conditions.
DCOUNTAReturns the number of numerical values in a column that satisfies multiple conditions (including logical values and text).
FREQUENCYReturns the number of times a particular value occurs.
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 numerical values in a list, table or cell range.
COUNTA
Returns the number of numerical values 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 numerical values that satisfies one condition.
COUNTIFS
Returns the number of numerical values that satisfies multiple conditions.
AGGREGATE
Returns the aggregate of values in a list, table or cell range.
DCOUNT
Returns the total number of numerical values in a column that satisfies multiple conditions.
DCOUNTA
Returns the number of numerical values in a column that satisfies multiple conditions (including logical values and text).
FREQUENCY
Returns the number of times a particular value occurs.
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.



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