Calculation Issues

Why Excel MIN Returns a Blank Result from Formula Cells

Muhammad TalhaMuhammad Talha Nov 18, 2026 868 views

Question details

Determine why a MIN formula appears blank when it references cells containing formulas.

Why Excel MIN Returns a Blank Result from Formula Cells
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user calculates the minimum of cells P59:P82 on the FDS RECTO sheet, where each cell contains a MIN formula referring to another range.
Observed behavior
The MIN result appears blank, although some referenced formulas may return zero because their source cells are empty.
Before you start

Select a few cells in 'FDS RECTO'!P59:P82 and check their formulas and source ranges. Confirm whether empty source rows should be excluded and whether genuine zero values should remain in the calculation.

Solution 1Recommended

Exclude empty source rows from the Excel MIN calculation

Use this approach when empty source rows should not affect the minimum but genuine numeric zeros should count.

MIN returns zero when its referenced range contains no numbers. A COUNT check can make an empty source row return an empty string instead, which MIN ignores in a referenced range.

1
Update the first source formula

On the FDS RECTO sheet, select P59 and enter =IF(COUNT(Q59:S59)=0,"",MIN(Q59:S59)).

2
Fill the formula down

Drag the fill handle from P59 down through P82 so each row checks its own Q:S range.

3
Update the overall minimum

In the result cell, enter =IF(COUNT('FDS RECTO'!P59:P82)=0,"",MIN('FDS RECTO'!P59:P82)). This leaves the result blank only when the range has no numeric results.

Exclude empty source rows from the Excel MIN calculation
Genuine zeros are retained: If a source range contains a numeric zero, it still counts toward the minimum. To treat all zero results as blank instead, use =IF(MIN(Q59:S59)=0,"",MIN(Q59:S59)) in P59 and fill it down.
Calculate with WPS Spreadsheets

Handle empty rows in a MIN formula with WPS Spreadsheets

Open the workbook in WPS Spreadsheets and use COUNT with MIN to exclude empty source rows while retaining genuine zeros.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Edit the source formula: On the FDS RECTO sheet, select P59 and enter =IF(COUNT(Q59:S59)=0,"",MIN(Q59:S59)).
  3. 3. Fill down: Drag the fill handle from P59 through P82 to apply the formula to the remaining rows.
  4. 4. Calculate the overall minimum: In the result cell, enter =IF(COUNT('FDS RECTO'!P59:P82)=0,"",MIN('FDS RECTO'!P59:P82)), then save the workbook.
Calculate a minimum without counting empty source rows as zerosOpen and save Microsoft Excel XLSX workbooksEdit formulas using familiar spreadsheet functionsFill formulas across a range of rows
microsoft office alternative - wps office

Frequently Asked Questions

Why does MIN return zero when the source cells are empty?

MIN returns 0 when its referenced range contains no numbers. A formula such as =MIN(Q59:S59) can therefore produce zero for an empty source row.

How do I show a hidden zero in Excel?

Go to File > Options > Advanced. Under Display options for this worksheet, select the worksheet and enable Show a zero in cells that have zero value.

Will MIN ignore formulas that return an empty string?

Yes. When MIN references a range, it ignores empty strings returned by formulas in that range. If the range contains no numbers, MIN itself returns 0.

How can I keep the overall result blank when every source row is empty?

First make empty source rows return an empty string, then use =IF(COUNT('FDS RECTO'!P59:P82)=0,"",MIN('FDS RECTO'!P59:P82)) in the result cell.

Will the COUNT approach exclude real zero values?

No. COUNT includes numeric zeros, so a genuine zero remains part of the MIN calculation. Use a zero-checking IF formula only if all zero results should be treated as blank.