0:00
hello and welcome to tut Tal's point in
0:02
this video we are going to understand
0:04
the count F function in Excel so here we
0:07
have this example data set of name and
0:10
sales and our question is we have to
0:12
find out how many team members met or
0:15
exceeded a sales Target of
0:18
$50,000 so here we are going to use the
0:21
account if function so here in this cell
0:24
I'll write the formula equals count if
0:27
and then open parenthesis now we have to
0:29
select the range in our case the range
0:31
is going to be the sales column so I'll
0:34
select this entire column and after the
0:36
range I'm going to write a comma and
0:38
then we have the criteria for the
0:40
criteria I'll write a quote and we are
0:43
looking for greater than
0:47
$50,000 so I'll just close the codes and
0:50
close parentheses and hit enter and the
0:53
answer is four which means we have four
0:55
team members who have met or exceeded a
0:57
sales Target of $50,000 and here we can
1:00
clearly see it from the data set the
1:02
first person is this as uh they have met
1:04
the sales Target then we have this one
1:07
then we have this one and this one so
1:09
exactly we have four persons as is the
1:12
answer now let's look at another example
1:15
here so here I'll click on sheet two and
1:18
inside sheet two we have this another
1:20
example and we have student and their
1:23
submission status so let's say these
1:25
students had to submit their assignments
1:28
and we are looking for the number of
1:30
students who submitted their assignments
1:32
late so as you can see this is the
1:34
student name and this is the status on
1:36
time late late on time on time and late
1:39
so we are looking for students who have
1:41
submitted their assignments late in this
1:43
case we can use the count if formula so
1:45
here in this cell I'll write
1:47
equals count F open parenthesis and then
1:50
the range now for the range we are
1:52
looking for this submission status
1:54
column and then comma and uh for the
1:57
criteria we are looking for late so I'll
2:01
just close the parenthesis and hit enter
2:04
and we have three students who have
2:05
submitted their assignments late and it
2:07
is pretty much clear here that these
2:09
three students are these three right so
2:13
this is another use case of count if
2:15
function now let's quickly jump to
2:17
another example for our practice so here
2:20
click on sheet three and we have uh this
2:22
another data set so we have items and we
2:26
have the stock stock status some items
2:28
are in stock and some items are out of
2:31
stock now we want to uh check how many
2:34
items how many number of items are out
2:36
of stock it's very simple we'll use the
2:39
count if formula here in this cell I'll
2:41
equals count if and then open
2:44
parenthesis and then for the range we
2:46
are going to select this stock status
2:49
and then a comma and for the criteria we
2:52
are looking for out of stock so I'll
2:54
write in quotes out of stock and then
2:59
I'll close the CL quotes and then the
3:01
parenthesis and hit enter so we have
3:03
four items that are out of stock which
3:05
is clearly visible here one 2 3 and four
3:10
so let's now uh quickly jump to the next
3:12
example so click here on sheet four and
3:15
here we have another example we have
3:18
employee and leave date and uh we are
3:21
basically looking for how many people
3:23
applied for leave on 15th of June
3:25
2025 all right so here we can again use
3:28
the count if function I'll write equals
3:32
count if open parenthesis and then range
3:34
we are looking for the leave dates so
3:36
I'll just select the entire column and
3:38
then comma and then for the criteria we
3:42
are looking for 15 June so I'll write
3:49
June 2025 and then I'll just close the
3:53
Cotes and the parentheses and hit enter
3:56
and we have three people who have
3:58
applied for leave on 15 of June as it is
4:01
clearly visible here this is the first
4:02
person this is the second person and
4:05
this is the third person so that will be
4:09
enough for this video now you can
4:11
download this practice sheet from the
4:12
link in the description below make sure
4:14
to like this video share it with your
4:16
friends and I will see you in the next
