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.
Example: following is the source data where we will count the car models
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:
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.
Example: in following example we will count number of cars where we have one cell blank and COUNTA will exclude the same:
It returns the count of blank cells in specified range. It takes only one range argument.
Example: in below example considering same data the Car name has one blank cell hence output would be 1