Use the status bar for simple counting in Excel, or use functions to count cells that contain data, are blank, or meet specific conditions or multiple criteria.

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

Suppose you want to find out how many times particular text or a number value occurs in a range of cells, there are several ways to count how often a value occurs.

How to count the number of unique values in a range that contains duplicate values in Excel.

Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range …

Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data. Select the cell where you want the result to appear.

Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, …

See examples of how to use worksheet functions to count numbers or dates that fall within a range in Excel.

The top reason why the #NAME? error appears in your formula is because there is a typo in the formula name. To avoid typos in formula names, use the Formula Wizard in Excel.

Count characters in cells by using the LEN function. This topic explains how to count one or more cells and use LEN in an array formula.