Excel’s MINIFS function is a potent resource that enables you to locate the smallest value according to one or more criteria. This tutorial will demonstrate how to use it by finding the lowest-scoring male and female students in a class.
Step 1: Add Data to Your Worksheet
To begin, incorporate the information you want to analyze to find the minimum amounts into your worksheet. For example, we will include a register of student names, genders and grades to find the lowest grade.
Step 2: Set Up Your Formula
Click an empty cell and type “=MINIFS(” to initiate the formula.
Step 3: Enter the Criteria
Next, enter the criteria you want to use for the minimum value search.
To find the minimum scorer female, type =MINIFS and then choose the marks range(in this case, C2:C14). Next, select the female range (B2:B14 for our example). In the criteria_range1 field, enter “F” (which indicates females).
The formula will become =MINIFS(C2:C14,B2:B14,“F”)
To find the lowest male scorer, we can use the same formula. In the formula bar, type =MINIFS and then set the marks range(C2:C14). Next, pick the male range (B2:B14). In the criteria_range1 field, enter “M” (which means males).
The formula will become =MINIFS(C2:C14,B2:B14,“M”)
To find the lowest female scorer in a specific class, we can use the MINIFS function with two criteria. Type =MINIFS and set the marks range (C2:C14). Next, pick the female range (B2:B14). In the criteria_range1 field, enter “F“, and in the criteria_range2 field, select the class range (D2:D14) and enter “X” in the criteria2 field.
The formula will become =MINIFS(C2:C14,B2:B14,”F”,D2:D14,”X”)
Once you have set the formula, hit Enter to get your result.
Conclusion
The MINIFS function is a powerful tool that can help you quickly locate the minimum value for one or more criteria. This tutorial has demonstrated how you can use it to find the lowest-scoring male and female students in a class. Experiment with the function using different criteria to become a pro at using this helpful function!
