How to Count Minimum Value for Groups

You can calculate the minimum value in a dataset with the MIN function. When calculating the minimum value within a group, you can get them using the pivot table, or using the formula below.

Example: In the following dataset, groups are in column A, regions are in column B and salaries are in column C.

Formula 1: To count the minimum value in group A

=MIN(IF(A2:A12="Group A", C2:C12))
=MIN(IF(A2:A12=A2, C2:C12))

IF(A2:A12="Group A", C2:C12): to create a new array with Group A's data, and data in other groups will become "false".

The group name can be replaced with the reference cell, e.g., A2 includes the value of "Group A" in this example.

The result returns $85,452.00.

Formula 2: To count the minimum value in group B using the MINIFS function

You can also use the MINIFS function if you have Excel 2019, Excel 365, or a later version. However, the result will return an error if you have the earlier version.

=MINIFS(C2:C12, A2:A12, "Group B")
(Excel 2019, Excel 365, or a later version)

The result returns $70,256.00.

Formula 3: To count the minimum value in group C

=MIN(IF(A2:A12="Group C",C2:C12))
=MINIFS(C2:C12, A2:A12, "Group C") - version 2019 or after

IF(A2:A12="Group C", C2:C12): to create a new array with Group C's data, and the data in other groups will become "false".

The group name can be replaced with the reference cell, e.g., A9 includes the value of "Group C" in this example.

The result returns $53,308.00.

Leave a Reply