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. In its …

How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.

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 …

To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function. To count …

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. In its …

If you do not need to count logical values, text, or error values (in other words, if you want to count only cells that contain numbers), use the COUNT function. If you want to count only cells that …

This article describes the formula syntax and usage of the DCOUNT function in Microsoft Excel. Description. Counts the cells that contain numbers in a field (column) of records in a list or …

View an example of how to use the COUNTA function to count cells that are not empty in a range of data.

The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using a …

You can count the number of values in a range or table by using a simple formula, selecting a button, or by using a worksheet function. Excel can also display the count of the number of …