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. This function is useful when you need to get the count of rows that have been filtered using the AutoFilter.
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. This function is useful when you need to get the count of rows that have been filtered using the AutoFilter.
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

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.
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.
COUNTNUMBEROFDAYSReturns the number of days in a specific month and/or year.
COUNTTEXTCELLSReturns the number of cells that contain text.
COUNTSUBSTRINGReturns the number of
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.
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.
COUNTNUMBEROFDAYS
Returns the number of days in a specific month and/or year.
COUNTTEXTCELLS
Returns the number of cells that contain text.
COUNTSUBSTRING
Returns the number of

More Counting Formulas

Counting Formulas contains a list of all counting relating formulas.



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