# Using MIN function in column with blanks

#### oldpup223

##### Board Regular
I have a scoring sheet that lists scores in a column but never know how many names will be entered and want to find the minimum score in a column with several blanks above the formula

#### Yongle

##### Well-known Member
Which version of Excel are you using

This formula is simplest but it is not available in earlier versions
=MINIFS(C:C,C:C,"<>")

Excel 2016 (Windows) 32 bit
A
B
C
D
E
F
1
100​
10​
=MINIFS(C:C,C:C,"<>")
2
25​
3
4
50​
5
75​
6
25​
7
10​
8
100​
9
1100​
10
27​
11
100​
12
13
59​
14
77​
 Sheet: Sheet4

Last edited:

#### Yongle

##### Well-known Member
From your post, I assumed that the you had tried the obvious
=MIN(C:C)

That works for me and ignore blanks. Does it not work for you ?

#### oldpup223

##### Board Regular
Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have
a +MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it woll not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give.

#### oldpup223

##### Board Regular
Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have
a +MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it woll not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give

What is a in
a +MIN(E5:I5)

#### oldpup223

##### Board Regular
Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have

=MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it will not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give

---End Quote---

#### Fluff

##### MrExcel MVP, Moderator
In what way is you formula not working?
Also are the blanks actually blank or do they show 0 as there is nothing in that row?

#### oldpup223

##### Board Regular
yes the cells are blank and after using =min(l5:l105) in cell l106 I just get a blank cell but the formula is still there

#### Fluff

##### MrExcel MVP, Moderator
Are you sure that your blanks are actually blank? Rather than contain a 0 that is hidden by formatting, or because you have unchecked "Show a zero in cells that have zero value"?