Thursday, January 22, 2015

Count The Number Of Cells With Text In Excel

      If you need to count a text in Microsoft Excel, what we do?

      We know =count ( ) formula  to count the number of cells with Contain number.

      But count the cells with Contain TEXT?

          = COUNTA ( )
    What Does It Do?
    This function counts the number of numeric or text entries in a list. 
    It will ignore blanks.
     Syntax      = COUNTA (Range1, Range2, Range3 ... through to Range30) 

    Example 1

      The following table show, how to count total no. of cell contain TEXT
                   =COUNTA( ) - COUNT( )


 Example 2
The following table was used by a school to keep track of the examinations taken by students
Each exam passed was graded as 1, 2 or 3.
A failure was entered as Fail.
The school needed to known how many students sat for each exam.
The school Also needed to know how many exams were taken by students .

The = COUNTA () function has been used because of its ability to count text and numeric entries.

Twitter Bird Gadget