# Difference Between COUNT and COUNTA in Google Sheets

The COUNT and COUNTA functions are two renowned functions in Google Sheets. We use these very often. But there are some differences between these 2 functions. The COUNT function can give results for only numerical values but the COUNTA function can give results for numerical, text, and other values. In this article, we’ll see the difference between the COUNT and COUNTA functions in Google Sheets with clear steps and images.

## Introduction to COUNT and COUNTA Functions in Google Sheets

The COUNT function in Google Sheets counts the total number of numerical values in a dataset. The syntax of the COUNT function is like below-

`COUNT(value1, [value2, ...])`

The COUNTA function in Google Sheets counts the total number of values in a dataset. The values can be text or numbers or other types. The syntax of the COUNTA function is like below-

`COUNTA(value1, [value2, ...])`

## 7 Differences Between COUNT and COUNTA Functions in Google Sheets

Let’s get introduced to our dataset first. Here we have some values in Column B and their meaning in Column C. I have put some values in text format and some values in number format. Now I’ll show you the difference between the COUNT and COUNTA functions in Google Sheets with the help of this dataset. ### Difference 1. Cell Having Text Value

The first difference between the COUNT and COUNTA functions is that the COUNTA function can count both the text and number formatted values. But the COUNT function can’t count the text-formatted values. It’ll only count the numerical values. The numerical values can contain a number or time or date but they shouldn’t contain any text. Below we’ll see the steps regarding this method.

Steps:

• Firstly, type the following formula in Cell B11
`=COUNT(B5:B8)`
• Secondly, hit Enter to get the result. • Then, write the following formula in Cell C11
`=COUNTA(B5:B8)`
• Next, press Enter to get the output. • Finally, you’ll see that there are 4 entries in Column B and the COUNTA function is counting them all. But the COUNT function is counting 3 because of having a text value in Row 5. ### Difference 2. Combination of Text and Number Values

Unlike, the previous method we have put a combination of text and number values in Cell B8 of our dataset to see how the COUNT and COUNTA functions react with them. When we put any combination of text and number values in any cell then both functions treat it like a text-formatted value. That’s why in this case the COUNTA function will count it but the COUNT function won’t. Let’s see the steps. Steps:

• At first, insert the following formula in Cell B11
`=COUNT(B5:B8)`
• After that, click Enter to get the desired result. • Thereafter, put the following formula in Cell C11
`=COUNTA(B5:B8)`
• Afterward, tick Enter to get the desired output. • At last, the COUNTA function will count all the entries but the COUNT function will count 2 out of 4. Because there are a text value in Row 5 and a combination of text and number value in Row 8. ### Difference 3. Cell Having Logical Value

Now, I have put a logical formula in Cell B9 of our dataset and get the output as TRUE. The formula is-

`=B6>B8`

Here, we’ll see that the COUNT function can not count any logical output. But the COUNTA function will count it easily. This is another difference between the COUNT and COUNTA functions in Google Sheets. Steps:

• First of all, type the following formula in Cell B12
`=COUNT(B5:B9)`
• Consequently, hit the Enter button to get the desired value. • Again, write the following formula in Cell C12
`=COUNTA(B5:B9)`
• Moreover, press the Enter button to get the result. • Ultimately, there are a text value in Row 5 and a logical value in Row 9. That’s why the COUNTA function counts all 5 entries but the COUNT function counts 3. ### Difference 4. Error Value in Cell

At this moment we have introduced an empty cell in Row 8 of our dataset. And also we are getting a #DIV/0! Error in Cell B9 because we have inserted the following formula where we divide a number by an empty cell-

`=B6/B8`

Now, we’ll see another difference between the 2 functions. Whereas the COUNT function will not count the error value but the COUNTA function will count it. Moreover, we’ll find that both functions can count an empty cell. Steps:

• In the first place, insert the following formula in Cell B12
`=COUNT(B5:B9)`
• Further, click the Enter button to get the output. • Apart from this put the following formula in Cell C12
`=COUNTA(B5:B9)`
• Also, tick the Enter button to get the value. • In the end, the COUNTA function will count 4 and the COUNT function will count 2. But there is a total of 5 entries. Both functions will not count the empty cell. And the COUNT function will not count the text value in Row 5 and the error value in Row 9. ### Difference 5. Having Some Spaces

When we have some spaces left in any cell which might seem like an empty cell but it isn’t. Then the COUNTA function includes that cell in its calculation. But the COUNT function ignores it. That’s the difference. Like here in our dataset we have some spaces left in Cell B8. Let’s see the difference between the COUNT and COUNTA functions in Google Sheets by using this dataset. Steps:

• In the beginning, type the following formula in Cell B11
`=COUNT(B5:B8)`
• As well as, hit Enter to get the desired result. • Besides, write the following formula in Cell C11
`=COUNTA(B5:B8)`
• In addition, press Enter to get the desired output. • Last but not least, the COUNT function is giving 2 and the COUNTA function is giving 4 out of 4 entries. In this case, the COUNT function is ignoring the text value in Row 5 and spaces in Row 8. ### Difference 6. Leading Apostrophe Before Any Value

There is an apostrophe sign (‘) before number 56 in Cell B8 of our dataset. For this reason, the format of the cell is changed to Text from Number automatically. So the COUNT function can’t count it this time. Steps:

• Before all, insert the following formula in Cell B11
`=COUNT(B5:B8)`
• Additionally, click Enter to get the desired value. • At this time, put the following formula in Cell C11
`=COUNTA(B5:B8)`
• Subsequently, tick Enter to get the result. • Finally, the COUNT function is ignoring the text value in Row 5 and the value leading with an apostrophe (‘) in Row 8. Thus producing the result 2. On the other hand, the COUNTA function is giving all the values. ### Difference 7. Having Symbols in Cell

Lastly, I have inserted some symbols in Cell B9 as you can see below. You’ll be amazed to see that the COUNTA function will count it quickly. But the COUNT function will ignore it and give the output without it. Steps:

• Earlier on, type the following formula in Cell B12
`=COUNT(B5:B9)`
• Then, hit the Enter button to get the value. • Next, write the following formula in Cell C12
`=COUNTA(B5:B9)`
• After that, press the Enter button to get the output. • In the end, you’ll see that the COUNT function is giving 3 and the COUNTA function is giving 5 out of 5 values. The COUNT function doesn’t give results for the text value in Row 5 and symbols in Row 9. ## Conclusion  