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.

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.

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.

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.

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.

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.

This topic lists the more common causes of the #VALUE! error in the COUNTIF and COUNTIFS functions.

Use this function to add the values in cells. Use this function to return one value if a condition is true and another value if it's false. Here's a video about using the IF function. Use this function when you need …

If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function. Copy the example data in the following table, and paste it in cell A1 of a new …