Excel Function | What is the Difference Between COUNT and COUNTA?

1 minute, 32 seconds Read


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:

COUNT and COUNTA excel function

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

COUNT and COUNTA excel function

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,

COUNT and COUNTA excel function

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

EduTaxTuber Team

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply