MS Excel: How to use the COUNTA Formula
|
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.011433
|
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)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
No comments:
Post a Comment