Saturday, 3 September 2016

COUNTA function | How to use the Excel COUNTA function | MS Excel: How to use the COUNTA Formula




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