Excel tutorials

A common task in Excel is to locate the smallest value in a group.

We are going to make use of the MINSIFS function in this example.

Follow the below steps:

• Enter some data in 2 columns.
• Select one cell
• Hit CTRL+T
• This will convert the data into a table.
• Name the table “Table1”

Below is the syntax for the MINIF function.

=MINIFS(min_range,range1,criteria1)

In our example:

• The first argument is the column AMOUNT
• The second argument is the column GROUP
• The third argument is the specific fruit

We are using structured references here, so to find the minimum value will look like this:

• =MINIFS(Table1[AMOUNT];Table1[GROUP];”Bananas”)

• To find the lowest value in the other groups, just change the third argument.