0:00
hey everyone welcome to tutorial's point
0:02
in this video we are going to understand
0:04
the count blank function this is perfect
0:06
for situations where you need to count
0:08
how many MPT sales are in your data like
0:11
when tracking follow-ups or attendance
0:14
now let's get started let's say we have
0:17
the sample data of salespersons and
0:19
these are the leads all right so we want
0:22
to check if they have done proper
0:25
follow-ups on these leads as well so as
0:28
you can see here is John he has uh
0:30
followed up on this lead one but not on
0:33
lead two and so on so I want to uh find
0:36
the total number of missing follow-ups
0:39
or basically the missing uh sales here
0:42
right the blank sales so in this case we
0:44
will use the count blank function it's
0:46
very simple here in this cell I'll write
0:49
equals and then uh count blank now
0:52
inside the count blank I will simply
0:54
select all of these cells that is our
0:56
data and then I'll just close the
0:58
parenthesis and hit enter and as you can
1:01
see the total number of missing
1:03
follow-ups are 33 now let's take a bit
1:06
more complex example so here I'll click
1:08
on the next sheet now in this sheet you
1:11
can see something I want to check for
1:13
missing follow-ups of a particular
1:16
salesperson let's say I looking for Jeff
1:19
and I want to look for the missing
1:20
follow-ups of Jeff let's count first
1:23
manually for Jeff the missing follow-ups
1:25
are 1 2 3 4 so here the answer should be
1:29
four now let's use the count blank
1:31
function but inside that count blank we
1:33
will use another function because we
1:35
want to filter this on the basis of a
1:38
sales representative right so in this
1:40
case what I'll do is I'll use the X
1:42
lookup function here I'll write
1:45
equals x lookup now inside the X lookup
1:48
first we have to give the lookup value
1:51
in our case it is this person so I'll
1:53
select this cell and then a comma then
1:56
we have the lookup array which means
1:58
where does this person come from it
2:00
comes from this column so I will select
2:02
this entire column then I'll write
2:04
another comma then we have the return
2:07
array which means where is our answer so
2:11
in this case I will select all of these
2:14
Columns of leads and then a comma and if
2:19
not found uh let's say I can have a
2:21
message here saying that not found and
2:24
that's all we need I'll just close the
2:26
parenthesis and now before hitting enter
2:29
we are going to wrap this entire formula
2:33
inside the count blank formula so here
2:35
before X look up I will write now count
2:38
blank formula I'll write
2:41
count blank and then open parenthesis
2:45
and then add the end I'll just close the
2:47
parenthesis if I hit enter as you can
2:50
see the Jeff has four missing follow-ups
2:53
exactly the same 1 2 3 and four now
2:57
let's look for some other employee let's
2:59
say Carl so if I write here c a r l it
3:03
has three following uh three missing
3:05
follow-ups as and as you can see 1 2 3
3:09
exactly so this is another use case of
3:12
account blank function in Microsoft
3:16
Excel and that's how you can use the
3:18
count blank function in Excel to count
3:20
blank cells for specific roles I hope
3:23
this helps make your data tracking a lot
3:26
easier don't forget to like this video
3:29
subscribe for more Excel tips and hit
3:31
the Bell so you never miss an update and
3:33
if you want to practice the Excel file
3:36
is linked in the description below
3:38
thanks for watching and I will see you
