Use the COUNTIF function in Microsoft Excel
How to use the COUNTIF function in Excel to count the number of cells that meet values you set.
COUNTIFS function - Microsoft Support
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.
COUNT function - Microsoft Support
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 …
Ways to count values in a worksheet - Microsoft Support
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.
Count numbers or dates based on a condition in Excel
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.
Ways to count cells in a range of data in Excel
COUNTA: To count cells that are not empty COUNT: To count cells that contain numbers. COUNTBLANK: To count cells that are blank. COUNTIF: To count cells that meets a specified …
Count unique values among duplicates - Microsoft Support
How to count the number of unique values in a range that contains duplicate values in Excel.
Calculate the difference between two dates - Microsoft Support
How to calculate the number of days, months, or years between two dates using the DATEIF function in Excel.
Count how often a value occurs in Excel - Microsoft Support
You can use the IF and COUNT functions together; that is, you first use the IF function to test a condition and then, only if the result of the IF function is True, you use the COUNT function to …
How to correct a #VALUE! error in the COUNTIF/COUNTIFS function
This topic lists the more common causes of the #VALUE! error in the COUNTIF and COUNTIFS functions.