How to use the MINIFS function in Excel
How to use the MINIFS function in Excel
Learn how to use the MINIFS function in Microsoft Excel. This tutorial demonstrates how to use Excel MINIFS with our easy to follow examples and takes you step-by-step through the different options when entering your formula.
MINIFS 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 -> maeín ifs is another statistical
2.25 -> function that has been introduced in
4.14 -> Excel 2019 and office 365 the main tips
8.88 -> function allows you to find the smallest
10.74 -> value in a range after applying one or
13.71 -> more criteria so let's get started here
16.859 -> we have a table of data that consists of
19.65 -> golf team player and score columns for
23.64 -> our first example let's find the minimum
25.59 -> score for group a we'll begin by
28.74 -> entering the min ifs command as you can
31.859 -> see the minion takes a number of
34.11 -> parameters the first parameter is the
37.23 -> range of cells that contains the
39.12 -> smallest or minimum value in this
42.51 -> example we'll use range c2 to c9 which
45.84 -> is our score column since we want to
48.3 -> find the minimum score the second
51.27 -> parameter is the range of cells to apply
53.25 -> your criteria against in this example
56.34 -> we'll enter the range a two to a nine
58.739 -> this is the range of cells that will
61.35 -> test to see if they meet our criteria
63.53 -> the third parameter is the criteria that
66.42 -> will be applied against the range a two
68.31 -> to a nine in our example will enter
71.67 -> Group A in quotes the bin if function
74.7 -> will test each value in the range A two
76.77 -> to a nine to see if the golf team is
79.56 -> Group A since we only want to apply one
82.409 -> criteria these are all the parameters
84.75 -> that we need so let's see what the
86.58 -> ministry turns
89.92 -> you should see the value 69 appear this
93.79 -> is a smallest score for Group A
97.25 -> now let's see how to apply two criteria
100.04 -> using the manip function so for this
102.98 -> example let's find the minimum score for
105.44 -> Group B where the score is greater than
107.63 -> zero again we will enter the minutes
110.36 -> command and start with the same first
112.52 -> two parameters that we entered in the
114.2 -> first example by entering the range c2
117.41 -> to c9 as the first parameter and a2 to a
121.73 -> nine as the second parameter this time
124.91 -> we will enter Group B in quotes as the
127.19 -> third parameter now it's time to apply
129.8 -> our second criteria by entering two more
132.41 -> parameters since we only want to include
135.35 -> scores that are greater than zero we
137.959 -> will enter the range c2 to c9 as the
140.99 -> fourth parameter which contains our
143.209 -> score values and greater than zero as
146.36 -> the final parameter the meanness
148.88 -> function will test each value in the
150.77 -> range c2 to c9 to see if it is greater
153.77 -> than zero now let's see what this
156.35 -> formula returns you should see the value
159.08 -> 75 appear as the result in this example
162.44 -> only the minimum score is included in
164.72 -> the calculations if both the golf team
167.06 -> is Group B and the score is greater than
169.519 -> zero so only these cells matched giving
173.57 -> us 75 as the smallest value finally
177.44 -> let's see how to use wildcards in the
179.48 -> minutes function in Excel there are two
182.269 -> different wildcard characters the
184.489 -> asterisk and the question mark the
187.37 -> asterisks allows you to match any string
190.04 -> of any length whereas the question mark
192.89 -> allows you to match only on a single
194.989 -> character let's use the asterisk
197.63 -> wildcard to find the minimum score for
200.299 -> all golfers whose name starts with the
202.4 -> letter S such as Sarah and Samantha so
206.09 -> again we will start with the minutes
207.53 -> function and enter the range c2 to c9 as
211.19 -> the first parameter then we will enter
213.62 -> the range b2 to b9 as the second
216.26 -> parameter which contains our player
218.09 -> names finally we will enter s asterisk
221.66 -> as the third parameter since we were
223.97 -> only looking at names to start with the
225.62 -> letter S now let's see what results we
228.17 -> get
229.569 -> you should see 78 appear as the result
232.45 -> which is the minimum score for all
234.37 -> players whose name starts with the
236.349 -> letter S so this would include players
238.81 -> such as Sarah and Samantha
241.89 -> and that covers our examples of how to
244.38 -> use excels minutes function if you would
247.2 -> like to see more examples or would like
249.209 -> to download the sample data we use for
251.1 -> this tutorial please visit our website
253.29 -> at tech on the Netcom we've also
255.51 -> included links in the comments below
258.73 -> if you have foundered tutorial helpful
261.07 -> please leave a like on this video and
262.87 -> don't forget to subscribe to our YouTube
264.67 -> channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=OGeHUT9wY90