How to use the COUNTIFS function in Excel
How to use the COUNTIFS function in Excel
Learn how to use the COUNTIF function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTIF to count cells based on one or more criteria. We provide 3 easy to follow examples and take you step-by-step through the different options when entering your formula.
COUNTIFS Function (and sample data):
https://www.techonthenet.com/excel/fo…
COUNTIF Function:
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.03 -> countifs is one of the statistical
1.92 -> functions in excel that you will find
4.14 -> very useful if you want to count the
6.839 -> number of cells that meet one or more
8.94 -> criteria countifs is the perfect
11.519 -> function it can even be used to replace
14.309 -> the countif function when you have a
16.68 -> single criteria let's start by looking
19.529 -> at how to use the countifs function when
22.08 -> you only have one criteria here we have
25.05 -> a table of data that consists of year
27.269 -> product and cost columns let's count the
30.689 -> number of cells that have a year equal
32.52 -> to 2013 let's begin by entering the
36.42 -> countifs command as you can see the
39.48 -> countifs function takes a series of
41.28 -> parameters that include first arrange
43.71 -> and then a criteria to apply it against
46.469 -> that range you can have up to 127 of
49.98 -> these range criteria pairs the first
53.01 -> parameter we will enter is the range of
55.02 -> cells that you want to apply the
56.67 -> criteria against in our example we will
59.64 -> enter the range a two to a nine this is
63.12 -> the range of cells that will be tested
64.89 -> to see if they meet the criteria
66.77 -> the second parameter we will need to
69.18 -> enter is the criteria that will be
71.159 -> applied against the range a two to a
73.409 -> nine this criteria can either be a value
76.619 -> or the reference to a cell that contains
78.54 -> a value in our example we will enter
81.57 -> quote equals 2013 quote the countif
86.25 -> function will test each value in the
88.259 -> range a two to a nine to see if it
90.6 -> matches the year 2013 since we only want
94.35 -> to apply one criteria these are all of
97.229 -> the parameters that we need to enter so
99.57 -> let's see what the countif function
100.65 -> returns you should see the value 4
103.92 -> appear this value is calculated by
106.92 -> examining the values in cells a2 to a
109.38 -> nine and counting only those cells that
112.11 -> contain the value 2013 in this example
116.549 -> cell a2 a 5 a 6 and a 8 were included in
122.369 -> the count
122.939 -> so our countifs function return the
125.07 -> value of 4 now let's see how to apply
128.28 -> two criteria let's count the number of
130.89 -> cells that have a year equal to 2013
133.92 -> and a product value equal to oranges
136.94 -> again we will enter the countifs command
139.68 -> and we will start with the same two
141.569 -> parameters that we entered in the first
143.34 -> example by entering the range a 2 to a 9
146.58 -> as the first parameter and quote equals
149.87 -> 2013 quote as the second now let's apply
154.17 -> our second criteria by entering two more
156.69 -> parameters we will enter the range b2 to
160.38 -> b9 as the third parameter and quote
163.02 -> equals oranges quote as the fourth
165.45 -> parameter the countif function will test
168.48 -> each value in the range b2 to b9 to see
171.72 -> if it matches the value oranges now
174.87 -> let's see what this formula returns you
178.05 -> should see the value to appear as the
179.73 -> result in this example cells are only
182.67 -> counted if both the year is 2013 and the
186.45 -> product is oranges so only these cells
189.6 -> matched
191.68 -> finally let's see how to apply three
194.079 -> criteria let's count the number of cells
196.93 -> that have a year greater than or equal
198.819 -> to 2009 a product of oranges and year
202.689 -> also less than or equal to 2012 again
206.799 -> we'll start with countifs and then enter
209.2 -> the range a two to a nine as the first
211.39 -> parameter and quote greater than equals
215.2 -> 2009 quote as the criteria to apply
218.2 -> against this range next we will enter
221.709 -> the range b2 to b9 as the next parameter
224.139 -> and quote equals oranges quote as the
228.01 -> criteria for this range finally we will
231.19 -> enter the range a two to a nine and
233.67 -> quote less than equals 2012 quote as the
238.06 -> criteria for this final range now let's
241.629 -> see what results we get you should see
244.54 -> one as the result since there is only
246.579 -> one instance where the Year is greater
248.62 -> than or equal to 2009 the product is
251.5 -> oranges and the year is less than or
253.48 -> equal to 2012
256.25 -> this covers our examples of how to use
258.799 -> excels countifs function if you would
261.799 -> like to see more examples or would like
263.78 -> to download the sample data we used for
265.76 -> this tutorial please visit our website
268.01 -> at tech on the Netcom if you found her
271.46 -> tutorial helpful please leave a like on
273.62 -> this video and don't forget to subscribe
275.6 -> to our YouTube channel for more great
277.52 -> Excel tutorials
Source: https://www.youtube.com/watch?v=Ihkgs7T3Do0