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