In the previous post we saw “How to join Text and numbers together?“, now we will see the” Difference between excel function COUNT and COUNTA”.
What is COUNT Function?
The COUNT function counts the number of cells that contain numbers and counts numbers within the list of arguments.
You can use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
Syntax
Count(value1, [value2],…)
Lets see with the help of example:
In the above example, you can see that the COUNT function returns the count of values that number. It ignores blank and text.
What is COUNTA Function?
The COUNTA function counts the number of cells in a range that are not empty.
Syntax
COUNTA(value1, [value2], …)
Let’s see with the help of same example
We can see in the above example it count both numbers and text but it does not count blank space ( as we can see in the above example cell B11 is blank cell so it ignores it).
There is a lot of practical uses of COUNT and COUNTA function when you are working in huge data in excel.
Difference Between COUNT & COUNTA
The function COUNT returns the count of values that number. It only count numbers and ignores the text and blank space.
Whereas the Function COUNTA: counts the number of cells in a range that are not empty. This means it will count all except the blank space as we can see in the above example,
In this way you can understand the difference between the COUNT and COUNTA function.
In the next post, we will see some more interesting excel functions that will be helpful more in practical life.
For Latest Updates & Learning Join Our YouTube Channel: Join Now