How to use the COUNTA function in Excel
How to use the COUNTA function in Excel
Learn how to use the COUNTA function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTA with our easy to follow examples and takes you step-by-step through the different options when entering your formula.
COUNTA Function (and sample data):
https://www.techonthenet.com/excel/fo…
Excel Functions/Formulas:
https://www.techonthenet.com/excel/fo…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.32 -> the count a function is a very handy
2.639 -> statistical function
3.84 -> in excel most commonly the count a
7.359 -> function
7.919 -> allows you to count the number of cells
9.92 -> that are not empty
11.679 -> but it can also count the number of
13.36 -> value arguments provided let's take a
16.64 -> quick look at how to use the county
18.4 -> function in excel
20.08 -> here we have a table of data that
21.68 -> includes five columns of data
24.32 -> in column a we have our student's last
26.4 -> name
27.359 -> in column b we have our student's first
29.359 -> name and in column c
31.599 -> d and e we have the students grades for
34.399 -> math biology and chemistry
37.28 -> let's use the count a function to count
39.36 -> the number of students that have a grade
41.12 -> for each subject
42.96 -> we will start with our formula that
44.559 -> counts the number of students with a
46.16 -> math grade
47.76 -> let's begin by entering the count a
49.6 -> command as you can see the count a
52.16 -> function takes a series of arguments as
54.32 -> parameters
55.92 -> each argument can be a range cell or a
58.48 -> value
59.28 -> and you can enter up to 255 arguments
62.879 -> to keep it simple today we will enter
64.72 -> the range c2
66.08 -> to c7 now let's see what our formula
69.84 -> returns
71.36 -> you should see the value 3 appear in
73.36 -> cell c8
75.04 -> this is the number of cells in the range
76.96 -> c2 to c7
78.64 -> that are not empty so cells c2
82.479 -> c5 and c6 are counted each as one
86.4 -> giving us the result of three this means
89.28 -> that there are three students that have
90.799 -> a grade for math
92.88 -> now let's copy our formula into cells d8
95.6 -> and e8
97.36 -> the formula in cell d8 returns the value
100.24 -> 2
100.88 -> which means that there are two students
102.479 -> with a grade in biology
104.72 -> and the formula in cell e8 returns the
107.36 -> value 4
108.399 -> which means that there are 4 students
110 -> with a grade in chemistry
112.32 -> this completes our example of how to use
114.399 -> excel's count a function
116.64 -> if you would like to see more counting
118.399 -> examples or would like to download the
120.479 -> sample data we used for this tutorial
122.96 -> please visit our website at
124.68 -> techonthenet.com
127.04 -> if you found our tutorial helpful please
129.2 -> leave a like on this video
130.72 -> and don't forget to subscribe to our
132.319 -> youtube channel for more great excel
134.44 -> tutorials
Source: https://www.youtube.com/watch?v=5a-VWPHJyMA