How to use the COUNTIF function in Excel to count the number of cells that meet values you set.

If you want to count logical values, text, or error values, use the COUNTA function. If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function.

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.

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.

Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.

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.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

View an example of how to use the COUNTIF function to count numbers greater than or less than a number in Excel.

How to calculate the number of days, months, or years between two dates using the DATEIF function in Excel.