MIN Not Working in Excel? Fix the Formula and Data

If MIN is not working in Excel, first check that the formula points to the cells you intend and that those cells contain real numbers. With values in A1:A10, enter =MIN(A1:A10); if the result is unexpected, use the checks below to find out whether the cause is zeroes, text-formatted numbers, a range mistake, or calculation settings.

What the MIN function does

MIN returns the smallest numeric value in the numbers or cell references you give it. It does not calculate an average or identify the smallest value that is currently visible on screen. For instance, with 12, 8, 0, a blank cell, and 15 in B2:B6, the formula =MIN(B2:B6) returns 0. The zero is a genuine number, so it is smaller than the other values; the blank is ignored.

MIN also ignores text and logical values such as TRUE and FALSE when they are stored in cells within a referenced range. Dates and times, however, are stored as numbers in Excel, so MIN can return the earliest date or time. This difference explains many results that seem surprising: a cell that looks numeric may be text and ignored, while a displayed date is still a numeric value to the function.

To see what Excel considers numeric, with candidate values in B2:B10, enter =COUNT(B2:B10). COUNT reports how many cells in that range contain numbers. It does not count blanks or text-formatted numbers. Compare that total with the number of cells you expected to include.

Check the formula and its range

A correct MIN formula can still return the wrong answer if its reference omits a row, includes an unrelated column, or points to another worksheet. Click the formula cell and inspect the colored range outline Excel displays while editing. Confirm that the first and last cells are right, and that the range includes all intended records but excludes headings and totals that should not be considered.

For example, if the values to compare are in C2:C50, a formula that stops at C49 misses the last record. If the heading in C1 contains a label, including it usually does not affect MIN because text in a referenced range is ignored, but explicitly selecting the data rows makes the formula easier to audit. A range can also shift when a formula is copied. Use an absolute reference if the range must stay fixed: with scores in B2:B20, =MIN($B$2:$B$20) keeps the same range when copied to another cell.

Check for a missing first or last row.
Confirm the formula refers to the intended sheet and column.
Look for hidden or distant values that may be included in a large range.
Check whether copying the formula changed a relative reference.

Why MIN returns 0 unexpectedly

Zero is often the correct result, even if it is not the value you expected. A cell may contain an actual 0, a formula that returns 0, or a formula that returns an empty-looking value under a custom number format. MIN includes numeric zero. Filtered-out rows and hidden rows can also remain part of an ordinary range, so a zero outside the visible portion may determine the result.

Inspect the cells in the selected range, including rows above and below the visible records. Click suspicious cells and look at the formula bar; a cell displaying a dash or blank may still contain zero. If the source cells contain formulas, check whether any of those formulas evaluate to 0. A custom number format can change how a value appears without changing the underlying value used by MIN.

When zero means “no measurement” in your data, decide whether it is truly a value or a missing-data marker. If it is missing information, correct the source data or use a function that applies an explicit condition. Do not simply remove zeroes unless the data rules justify it: a real zero measurement is usually a valid minimum.

Numbers stored as text are ignored

A value such as 42 can look exactly like a number while being stored as text. This can happen after importing a CSV file, copying data from a website, or using an apostrophe before the value. Text-formatted numbers in referenced cells are ignored by MIN, which can make the result too large or cause MIN to return 0 if the range contains no actual numbers.

Look for green error indicators, left-aligned values, or a warning icon when you select a cell; these can suggest a number is stored as text, though alignment alone is not proof because formatting can change alignment. The COUNT check above is a useful confirmation. If the imported values should be numbers, select the affected cells and use Excel’s warning menu to choose Convert to Number when that option appears.

For a whole imported column, another practical conversion method in Windows desktop Excel is to select the cells, choose Data > Text to Columns, and complete the wizard with the appropriate delimiter settings. For a simple column with no delimiter splitting required, choosing Finish can convert numeric text in place. Make a copy first if the column contains mixed data, since the wizard can alter how values are divided or interpreted. Then recalculate or inspect MIN again.

Fix errors and formula-entry problems

If the cell displays an error such as #VALUE! or #REF!, inspect the formula and its referenced cells. A deleted or invalid reference can produce #REF!, while an error value already present in the input range can cause the MIN calculation to return an error rather than a minimum. Fix the source error or deliberately exclude that source cell; hiding the error with formatting does not remove it from the calculation.

Check that the formula begins with an equals sign, uses parentheses correctly, and refers to a valid range. In English-language Excel, this is a valid range formula: =MIN(B2:B10). A common issue is entering it while the cell is formatted as Text, which makes Excel display the formula characters instead of calculating them. Change the cell format to General, edit the cell, and press Enter. Merely changing the format may not convert an already-entered text string into a formula until you re-enter it.

In some regional settings, Excel uses a different list separator in formulas. If a formula has multiple arguments, use the separator expected by your Excel settings; a simple one-range MIN formula has no argument separator to change. Also check for a leading apostrophe, which tells Excel to treat the entry as text.

Filtered lists and hidden rows

MIN examines every numeric cell in its referenced range, including rows hidden by a filter. That behavior is useful when you want the true minimum across all records, but not when you mean “the smallest value among the rows currently visible.” For filtered data in B2:B10, =SUBTOTAL(5,B2:B10) returns the minimum among the visible rows. In a sample where visible values are 18, 11, and 24, and a filtered-out row contains 7, the result is 11.

SUBTOTAL function number 5 calculates a minimum and excludes rows removed by a filter. It does not exclude rows hidden manually. If manually hidden rows should also be excluded, use function number 105 instead: with the same values in B2:B10, =SUBTOTAL(105,B2:B10) calculates the minimum while excluding filtered-out and manually hidden rows. Be clear about which behavior you need before replacing MIN; otherwise the result may change simply because someone applies a filter or hides a row.

Check calculation and display settings

Sometimes the formula is right but the displayed result has not updated. In Windows desktop Excel, go to Formulas > Calculation Options and check whether calculation is set to Automatic. In Manual mode, changes to input cells may not recalculate dependent formulas until calculation is triggered. Press F9 to recalculate open workbooks, or switch back to Automatic if that is the intended workbook behavior. Mac ribbon options can vary by release, but look under the Formulas tab for Calculation Options.

Another display issue is Show Formulas mode, which displays formulas in cells rather than their results. On Windows, Ctrl+` (the grave accent key, usually near the top-left of the keyboard) toggles this view. You can also use Formulas > Show Formulas. If every formula on the sheet appears as text, this setting is a likely explanation. If only one formula appears as text, check that cell’s format and whether it was entered with an apostrophe.

Finally, distinguish an outdated value from a formula that is correct but based on old inputs. Confirm the source cells changed as expected, check for external links or query refreshes if the values come from outside the workbook, and recalculate. A formula cannot include newly imported or appended data if its range does not cover those rows.

Use MINIFS when you need a condition

MIN does not filter values by category, date, or status. If you need the minimum for records that meet a condition, MINIFS is designed for that task. With regions in A2:A20 and amounts in B2:B20, where the North rows contain amounts 160, 125, and 175, enter =MINIFS(B2:B20,A2:A20,"North"). The result is 125. MINIFS is available in Excel 2019 and later, including Microsoft 365.

The first argument is the range to find the minimum in; each following pair gives a criteria range and a condition. Make sure the criteria range is the same size and shape as the minimum range. If no records match, MINIFS returns 0, which can look like a real minimum. Check that the condition text matches the data, including unexpected spaces, and confirm at least one qualifying amount is numeric. For more complex conditions or older Excel versions, a filtered helper column or another compatible approach may be more suitable.

Frequently Asked Questions

Why does MIN return 0 when there are no zeroes?
If the referenced range contains no numeric values, MIN returns 0. Check for numbers stored as text, a range that misses the real values, or formulas that display blanks but return zero. COUNT can help establish how many numeric cells Excel sees.

Does MIN ignore blank cells?
Yes. Blank cells in a referenced range are ignored, as are text and logical values stored in cells. Numeric zero is not blank and is included, while a formula returning an empty string is text rather than a numeric measurement.

Can MIN find the smallest visible value after filtering?
Not by itself; MIN still considers filtered-out rows in its range. Use SUBTOTAL with function number 5 to find the minimum among filtered visible rows. Use 105 if manually hidden rows should be excluded as well.

Why is my MIN formula showing instead of a result?
Check whether the cell is formatted as Text, begins with an apostrophe, or whether Show Formulas is enabled for the worksheet. Set the cell to General and re-enter the formula if needed, or toggle Show Formulas off.

What is the difference between MIN and MINIFS?
MIN returns the smallest number across the supplied values or range. MINIFS returns the smallest number only among cells whose corresponding records meet one or more conditions, such as a particular region or status.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.