Lesson#63: COUNT, COUNTA, COUNTBLANK explaination

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.

COUNT COUNTA COUNTBLANK

 










Related video tutorial:

See also  Short Tips#0075: How to find out complete blank rows in data sheet

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

Your email address will not be published. Required fields are marked *

*