Counting Functions
Worksheet Functions
| 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. |
| 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. |
| 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. |
| 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. |
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
| COUNTTEXTCELLS | Returns the number of cells that contain text. |
| COUNTTEXTCELLS Returns the number of cells that contain text. |
Add-in Functions
| COUNTBETWEEN | Returns the number of cells that have a value that is between "min_value" and "max_value". |
| COUNTFORMAT | Returns the number of cells that have been formatted with multiple attributes. |
| COUNTHIDDENSHEETS | Returns the number of hidden worksheets in the active workbook. |
| COUNTSUBSTRING | Returns the number of times a substring occurs in a larger text string. |
| COUNTUNIQUE | Returns the number of unique values in a particular range. |
| COUNTVISIBLE | Returns the number of visible non blank cells. |
| COUNTIFSVISIBLE | Returns the number of visible non blank cells that satisfies multiple conditions. |
| COUNTBETWEEN Returns the number of cells that have a value that is between "min_value" and "max_value". |
| COUNTFORMAT Returns the number of cells that have been formatted with multiple attributes. |
| COUNTHIDDENSHEETS Returns the number of hidden worksheets in the active workbook. |
| COUNTSUBSTRING Returns the number of times a substring occurs in a larger text string. |
| COUNTUNIQUE Returns the number of unique values in a particular range. |
| COUNTVISIBLE Returns the number of visible non blank cells. |
| COUNTIFSVISIBLE 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.
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext