COUNTA Function (Functions in Excel)
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.53105 | 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) | ||||||
0 comments:
Post a Comment