There are two common ways to use the **MIN** function in Google Sheets to find the minimum value in a range while excluding cells that are equal to zero:

**Method 1: Use MIN & FILTER**

=MIN(FILTER(B2:B15, B2:B15<>0))

**Method 2: Use MINIFS**

**=MINIFS(B2:B15, B2:B15, "<>0")**

Both formulas find the minimum value in the cell range **B2:B15**, excluding any cells that are equal to zero.

The following examples show how to use each method in practice with the following dataset that shows the number of sales made by various employees at some company:

**Example 1: Use MIN & FILTER**

We can use the following formula with the **MIN** and **FILTER** functions to find the minimum value in the sales column while excluding all values equal to zero:

=MIN(FILTER(B2:B15, B2:B15<>0))

We’ll type this formula into cell **D2** and then press Enter:

From the output we can see that the minimum value in the sales column (excluding all values equal to zero) is **2**.

This formula works by first filtering the range for values that are not equal to zero, then finding the minimum of the remaining values.

**Example 2: Use MINIFS**

We can use the following formula with the **MINIFS** functions to find the minimum value in the sales column while excluding all values equal to zero:

**=MINIFS(B2:B15, B2:B15, "<>0")**

We’ll type this formula into cell **D2** and then press Enter:

From the output we can see that the minimum value in the sales column (excluding all values equal to zero) is **2**.

This formula works by finding the minimum value in the range only *if *the value in the range is not equal to zero.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Find Max Value by Group

Google Sheets: Calculate Average Excluding Outliers

Google Sheets: How to Calculate a Trimmed Mean