The COUNT function returns the absolute number of cells that include numbers. This count contains both Numbers and Dates.
Syntax
1. COUNT (value1, [value2]…)
Where the parameters, value1, [value2], etc. can be any values or authority to cell ranges.
Example 1: The following illustration returns the number of integer values in a given range.

Example 2: The following illustration count integer Values in the range A1: A4 and B1:B2.

EXCEL COUNTIF

Excel COUNTIF function is utilized for counting cells inside a selected range that meet a specific rule, or condition.
For example, we can write a COUNTIF equation to discover out how many cells in our worksheet include a number higher than or less than the number we consider. Another common use of COUNTIF in Excel is for counting cells with a particular word or beginning with a specific letter(s).
Syntax
The syntax for a COUNTIF function in Microsoft Excel is:
1. COUNTIF (range, criteria)
Where
range: The range of cells that is examined against the given criteria.
Criteria: The condition which needs to be examined against each cell in the range.
Note: If our criteria is a text string or a statement, then it must be enclosed in the double-quotes.
Example: The COUNTIF function following counts the number of cells that are higher than or equivalent to 5.

Excel COUNTIFS

The Excel COUNTIFS function takes in at least one cell range and returns the total counts if criteria are fulfilled.
Syntax
1. COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2],…)
Where criteria_range1: Arrays of values (or ranges of cells including values) to be examined against the particular criteria1, criteria2 … (The provided criteria_range arrays must all have the similar length).
criteria1: The conditions to be examined against the values in the criteria_range1, [criteria_range2]
Example 1: The following example displays the use of the COUNTIFS function.
In this example, we want to count the number of persons who fulfilled these two criteria.
1. A person should be female.
2. A grade should be <=D, which is between A to C.

Example 2: Count the total number of candidates who have failed in the exam.”*male” is utilized to discover the cells which end with a male.

Excel Advanced If Functions

=IF (AND(B3>50,C3>50),B3+C3,B3*C3)
The IF function says if values of both cells B3 and C3 are greater than 50 then add these cells else multiply these cells. See the image given below.

=IF(B4>AVERAGE (C4:C9),”cell B4>average”,””)
The IF function says if value in cell B4 is greater than the average of the cells from C4 to C9 then display “cellB4>average” else leave the cell blank.

So, this brings us to the end of blog. This Tecklearn ‘How to use COUNT, COUNTIF and COUNTIFS Function in Excel’ blog helps you with commonly asked questions if you are looking out for a job in Microsoft Excel. If you wish to learn Excel and build a career in Business Intelligence domain, then check out our interactive, Microsoft Power BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Microsoft Power BI Training

Microsoft Power BI Training

About the Course

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

Why Should you take Microsoft Power BI Training?

• The average annual pay for a Power BI Professional is $114,000 . -PayScale.com.
• Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc, Brillio and 45,000 MNCs across 185 countries use Power BI and it has a market share of around 7% globally.
• Microsoft Power BI has been ranked at No.1 position in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 13 consecutive years.

What you will Learn in this Course?

Introduction to Microsoft Power BI
• Microsoft Power BI Introduction
• Power BI Products
• Power BI Architecture
• Installing Power BI
• Connecting to Data Sources
Power BI Workflow
• Key features of Power BI workflow
• Power BI Vs MSBI
• History of Power BI
• Power BI Products
• Data modelling and relationships
Power Query for Data Transformation
• Power Query for Data Transformation
• Learning about Power Query for self-service ETL functionalities
• Working with Excel data
• Introduction to Query Editor
• Data transformation
• Pivot and UnPivot
• Merge Join, relational operators, date, time calculations, working with M functions
• Summary Tables
• Writing custom functions and error handling
• M advanced data transformations
Filters and Drill Down Report
• Visualization Filter
• Page Level Filter
• Report LEVEL Filter
• DRILL Through Filter or Report
• BookMark Report
Power Pivot for Data Modelling
• What is SSAS
• Data Modelling
• Star Schema
• Snowflake Schema
• Introduction to MDDB and Tabular
• Data Access Modes
• Tabular with DAX
• Power BI with DAX
• DAX Functions
Data Analysis Expression – DAX Queries
• TABULAR with DAX
• Power BI with DAX
• Calculated Members, Row, Filter & Evaluation Context
• Cumulative Charts
• Calculated Tables, ranking and rank over groups
• DAX advanced features
Power BI Desktop & Administration
• Reports and Visualization
• Learning about data modelling and data relationships
• Deploying data gateways
• Reports and Dashboards
• On Premises Data Gateway
• Gateway Clusters
Introduction to Power Q & A
• Power Service
• Power Q & A best practices
• Integrating with SaaS applications
• Gateway

857