Learn Excel COUNTIFS Function

Career Guidance
1 follower
Nov 1, 2024
Service desk Analyst complete course
https://www.udemy.com/course/it-support-help-desk-service-desk-analyst-crash-course/?referralCode=2BEA91E82EF0A43B7F09
Citrix virtual apps and Desktop complete course
https://www.udemy.com/course/citrix-virtual-apps-and-desktops-7x/?referralCode=B4AFFADD3E44142E746D
please do use the above link only while buying the course so I will get max amount.
The next function is the COUNTIFS.
You might get a glimpse of what this means, given the S.
The COUNTIFS function allows you to count cells in a range based on multiple criteria.
The syntax of the COUNTIFS is the criteria range 1, the criteria range 2, then the criteria.
This is the syntax of the COUNTIFS.
The conditions are referred to as criteria.
It can be criteria 1, 2, or more.
And these criteria can be things like when a number is less than another number,
or greater than another number, or the text is equal to something.
The major difference between the COUNTIFS and the COUNTIFS is
The COUNTIFS accept only one condition, but the COUNTIFS accept multiple conditions.
Now the criteria range 1 and so on are the ranges where the function checks for the condition.
So when we select the criteria range, we also need to select the criteria.
Now this criteria range is where the function will check for the conditions.
Let's try to apply the COUNTIFS function by looking for male accountants.
Meaning, we'll start with the job title.
That is accountant.
And then we want to see, do we have male accountants?
How many male accountants do we have?
You start by typing your COUNTIFS function.
You select the first criteria.
That's the criteria range.
Now what's the criteria inside this criteria range?
It's accountant.
The next criteria is the gender.
We are looking for male accountants.
We want to count how many male accountants do we have in this organization.
By selecting the gender.
What are we looking for in the gender?
We're looking for male.
Well, you close the bracket and enter.
It turns out we only have one male accountant in this organization.
Let's try to solve through manually and see if we can pick that out.
So this is the first accountant.
It's a female.
This is the next accountant.
It's a male.
Which is why we have one.
Let's try another example.
By looking for how many female staffs are above 30 years.
So we start by putting the function COUNTIFS.
COUNTIFS.
The first criteria range is the gender.
What are we looking for inside the gender?
We are looking for females.
The next criteria is the age.
We are looking for females who are 30 and above.
We want to count. We want to know how many females are 30 and above.
You type in greater or equal to 30.
Close. Enter.
Now we can see that we have just 3 females that are 30 years and above.
We can check that to confirm.
This is female 1.
This is female 2.
And this is female 3.
So this means we have 3 females that are 30 years and above.
Try to practice with more conditions.
And see if you would get an output.
To understand how these 3 functions work.
The next function we will discuss is the COUNTBLANK function.
The COUNTBLANK allows you to count blank cells in a ring.
It is written as equal to COUNTBLANK.
Just like the name implies, COUNTBLANK.
Meaning counting blank cells.
This function is very helpful to help find cells in a range that are empty.
So the COUNTBLANK function is very helpful to find empty cells in a range.
Let's look at examples of how you can apply COUNTBLANK.
For example, you have this data.
And you want to verify if there are empty cells in it.
The best function to use is COUNTBLANK.
COUNTBLANK would allow you to select the whole range.
To determine if there is an empty value.
COUNTBLANK would also allow you to select column by column.
To determine if there is any empty cell in the column.
Let's try.
Let's look at this column by column.
So let's start from the employee ID column.
Equal to COUNTBLANK.
I'll select the whole employee column.
From A2 to A10.
Now we can see we have two empty cells in employee ID.
Let's look at it and see if we can detect those empty cells.
Do we have one?
No, we have two.
This means the COUNTBLANK function gave us the correct answer.
Let's look at the job title.
If there is an empty cell.
Remember range?
Salt?
It gives us zero.
Looking at the job title, we can see that there is no empty cell in it.
Let's try to count the whole data.
And see the total blank cells we have.
You start by selecting.
At this point, you should be familiar with drag and drop.
How to select multiple cells.
How to select multiple columns.
Which is what we're doing here.
Now we started from A2 to A10.
Close the bracket and enter.
It's showing us that for the total data, we have five empty cells.
We can start by counting it and it's a very small value.
So let's count manually and see.
We have one.
We have two.
We have three.
We have four.
And we have five.
This means that countBLANK function is correct.
Try to practice this and see if you understand how this function works.
