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.

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 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.

Watch the following video to see how to use the COUNT function and how to use the COUNTIF and COUNTA functions to count only the cells that meet conditions you specify.

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.

There are several ways to count how often a value occurs. Use the COUNTIF function to count how many times a particular value appears in a range of cells. For more information, see COUNTIF function.

在 Excel 中使用 COUNTIF 的示例 要在 Excel 中使用这些示例，请复制下表中的数据，然后将其粘贴进新工作表的 A1 单元格中。

Use COUNTIF to count the number of cells that meet a specific criteria. For example, you are preparing a report and want to count how many sales invoices were greater or lesser than a particular value.

COUNTIF: To count cells that meets a specified criteria. To enter more than one criterion, use the COUNTIFS function instead. Select the range of cells that you want, and then press RETURN.

If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function. Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.