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
Save Up to 85% LIMITED TIME OFFER
A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
