What is the use of COUNTIF function?
COUNTIF Function in Excel counts all numbers in a range based on a given criteria
50+ Project Management Templates Pack
Excel PowerPoint Word
Advanced Project Plan & Portfolio Template
Business Presentations Templates Pack
20+ Excel Project Management Pack
20+ PowerPoint Project Management Pack
10+ MS Word Project Management Pack
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