Lesson#63: COUNT, COUNTA, COUNTBLANK explaination
Here I will discuss three functions COUNT, COUNTA, and COUNTBLANK, and show their similarity or difference.
|
COUNT
|
COUNTA
|
COUNTBLANK
|
|
|
Description
|
The COUNT function counts the number of cells that contain
numbers |
The COUNTA function counts the number of cells that are not empty
in a range. |
COUNTBLANK function counts the number of empty cells in a
range of cells. |
|
Syntax
|
COUNT(value1, [value2], …)
|
COUNTA(value1, [value2], …)
|
COUNTBLANK(range)
|
Example of COUNT
Here is a column I have put both numbers and letters and applied the COUNT function in this range. This function only counts the numbers.
So use the COUNT function when the values to be counted are only numbers.
Example of COUNTA Here is a column I have put both numbers and letters and applied the COUNTA function in this range. This function counts all the nonvacant cells.
So use the COUNTA function to count those cells which have any values.
Example of COUNTBLANK
Here in a column I have put both numbers and letters and applied the COUNTBLANK function in this range. This function counts only empty cells.
Related video tutorial:
Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.
Leave a Reply