What is the use of COUNTIF function?
COUNTIF Function in Excel counts all numbers in a range based on a given criteria
What is the syntax of COUNTIF function?
COUNTIF( range, criteria )
range: range of cells that you want to check the criteria and count
criteria: condition which you want to apply
COUNTIF Function in Excel – Examples
Example 1: counting the salaries more than 2500
Example 2: counting the number of departments named “HR”
Example 3: counting the number of occurrences Years 2011
Reference:
Please refer the below article for more Statistical Excel functions.
Statistical Excel Formulas
Please refer the below article for more Excel Functions.
Excel Formulas | Home