Counting Functions
Worksheet Functions
| 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. |
| 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
| COUNTIF | Using the COUNTIF function with multiple conditions. |
| COUNTIFS | Using the COUNTIFS function with multiple conditions. |
| SUMPRODUCT | Using 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
| 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. |
| 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