hello and welcome to our new video
in this video we are going to learn
about three formulas
first is count, second is count blank and third is count
now what are these three formulas doing
to see this thing
we have to open excel
so let's go to excel
and you will see
that here I have written three formulas
along with this
I have selected some of my grid lines
and highlighted
this color
and all other cells
you can see
this is not a table
what I have done is
I have blacked the border of grid lines
this question is asked to me many times
that how to do this
so I am going to tell you this
what you have to do is
first I will remove this
and then I will show you again
now you will see
all the grid lines
in sheet no.1 are looking similar
there is no highlighted color
so first
you have to select those cells
which you want to highlight
you want to highlight with black color
now you can take any color
like I have selected
all the cells
which I have selected
should look highlighted
so what I have to do
I have to go to font group
here I have to
go to more borders
here I have to select
some styles
you can select
dotted line or plain line
now you can see
the thickness of this line
if you want to take double line
you can take double line
now I am selecting this line
now you can
change the color of this line
I am leaving it black
now you have to select outline
you can see
this outline
here you can see
the outline
if you click inside
you can see the outline
here you can change
the color of inside and outline
you can change the color of inside and outline
so after that
you have to click ok
now you can see
all the cells are different
because they are highlighted
now let's talk about
how these formulas work
first formula is
COUNTA
for COUNTA
you have to write
equals
COUNTA
double click and
value
select all the cells
and
close bracket and enter
now value
is showing 0
now why it is showing 0
and what is COUNTA
I will write any name
I will write any number
I will write any special character
so COUNTA will count
1,2,3
like I am writing here
let's increase the size of this
here I am writing
my name
I am writing
Rahul
and press enter
now you can see
number is changed
or I can press space
and press enter
so it counts the space
or I can write
at the rate
now it is 3
after that
I am writing
23
and press enter
whatever I am writing
whether it is a name or number
or any special character of keyboard
it counts
COUNTA
what is COUNTBLANK
you can know from the name
that all the blank cells
it counts
let's see
total number of cells
1,2,3,4,5,6,7
7 is rows
and
1,2,3,4,5,6
means 42
42 cells
so COUNTA
should be 42-4
should be 38
let's see
here you have to put a question
after that COUNTA
and here
we have to select
all the data
after that we close it
press enter
so the answer is 38
after that
what is COUNTA
what is the difference between COUNTA and COUNTA
this is something to understand
this is asked in academics
many times
so let's use COUNTA
let's see
all the numbers or special characters
let's apply it
and see the result
so we wrote equals to COUNTA
and
we selected all the data
and entered
so you will see
1 is written here
so COUNTA counts the numbers
rest of the things
special characters
will not be counted
name will not be counted
number will be counted
let's see
does it counts the decimal values
23.67
so yes
because it is a kind of number
so you will see
as I change the numbers
5 is there
1,2,3,4
now you will say how 5 is there
space is also there
so let's see
now all the things will be changed
like I write a number here
I write
22
and after entering what should be there
6 should be there in COUNTA
in COUNTA blank
1 is less
because it is 22
so here 36 should be there
here 6 should be there
and here 3 should be there
am I right
let's enter
here 6, here 36, here 3
so I am right
now let's see
my surname
I write Rohila
and then I enter
now what is the answer
think in your mind
answer should be
7, 35
and 4
no 3
so let's enter
7, 35, 3
because when I write Rohila
it is not a number so COUNTA will consider it
COUNTA will consider everything
and COUNTA blank will do
that all the blank cells I have
will be counted
I hope you understood
what we have done in this
if you still have any doubt
then play this video again
I will meet you in next video
till then keep practicing