.

COUNTA Function Dictionary

Function Dictionary Function Examples Function Categories

COUNTA          
 
 
Entries To Be Counted Count
10 20 30 3  =COUNTA(C4:E4)
10 0 30 3  =COUNTA(C5:E5)
10 -20 30 3  =COUNTA(C6:E6)
10 1-Jan-88 30 3  =COUNTA(C7:E7)
10 21:30 30 3  =COUNTA(C8:E8)
10 0.3025 30 3  =COUNTA(C9:E9)
10   30 2  =COUNTA(C10:E10)
10 Hello 30 3  =COUNTA(C11:E11)
10 #DIV/0! 30 3  =COUNTA(C12:E12)
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)
Formatting              
No special formatting is needed.
Example                
The following table was used by a school to keep track of the examinations taken by each pupil.
Each exam passed was graded as 1, 2 or 3.
A failure was entered as Fail.
The school needed to known how many pupils sat each exam.
The school also needed to know how many exams were taken by each pupil.
The =COUNTA() function has been used because of its ability to count text and numeric entries.
Maths English Art History Exams Taken
By Each Pupil
Alan Fail   1   2
Bob 2 1 3   3
Carol   1 1 1 3
David Fail   Fail   2
Elaine 1 3 2 Fail 4
 =COUNTA(D39:G39)
How many pupils sat each Exam.
Maths English Art History
4 3 5 2
 =COUNTA(D35:D39)

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download