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?

Advertisements

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

author

EduTaxTuber Team

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

Similar Posts

Leave a Reply

Realme 10 Pro and 10 Pro+ Launched RBI Monetary Policy Highlights England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence