COUNT, COUNTA and COUNTBLANK functions Excel Add-in with example

COUNT, COUNTA and COUNTBLANK functions Excel Add-in with example

COUNT

The COUNT function is generally used to count a range of cells containing numbers or dates excluding blanks. It takes upto 25 argument as value parameters.

Syntax

=COUNT(value1,value2,value3….value225)

Example: following is the source data where we will count the car models

figure 1.1

Formula: put following formula to count the models, Note if you try to count cars located in column “A” the result will come ZERO as shown below in figure 1.3:

figure 1.2

Output

figure 1.3

COUNTA

will count everything like numbers, dates, text or a range containing a mixture of these items and blank cells. In other words COUNTA stands for count all. It takes upto 25 argument as value parameters.

Syntax

=COUNTA(value1,value2,value3….value225)

Example: in following example we will count number of cars where we have one cell blank and COUNTA will exclude the same:

Output

COUNTBLANK

It returns the count of blank cells in specified range. It takes only one range argument.

Syntax

=COUNTBLANK(range)

Example: in below example considering same data the Car name has one blank cell hence output would be 1

Output

Next >> Update bulk formulas in Excel Sheet step by step

Leave a Reply

Your email address will not be published.