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.904007
|
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)
| |||||||||
Wednesday, 18 September 2013
COUNTA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment