# Thread: Using MIN function in column with blanks Thanks: 0 Likes: 0

1. ## Re: Using MIN function in column with blanks

HIJKL
1040.0000.0000.000
1050.0000.0000.000
106#NAME ?

Score Entry

Worksheet Formulas
CellFormula
H100
H101
H102
H103
H104
H105
H106

and this is what I get trying all versions that you have offered #NAME ?

2. ## Re: Using MIN function in column with blanks

GHIJKLM
1000.0000.0000.000
1010.0000.0000.000
1020.0000.0000.000
1030.0000.0000.000
1040.0000.0000.000
1050.0000.0000.000
106#NAME?

Score Entry

Worksheet Formulas
CellFormula
J100=SUM(E100+F100+G100+H100+I100)
K100=SUM(J100/5)
L100=MIN(E100:I100)
J101=SUM(E101+F101+G101+H101+I101)
K101=SUM(J101/5)
L101=MIN(E101:I101)
J102=SUM(E102+F102+G102+H102+I102)
K102=SUM(J102/5)
L102=MIN(E102:I102)
J103=SUM(E103+F103+G103+H103+I103)
K103=SUM(J103/5)
L103=MIN(E103:I103)
J104=SUM(E104+F104+G104+H104+I104)
K104=SUM(J104/5)
L104=MIN(E104:I104)
J105=SUM(E105+F105+G105+H105+I105)
K105=SUM(J105/5)
L105=MIN(E105:I105)

Array Formulas
CellFormula
L106{=MINIFS(L5:L105,L5:L105,"<>0")}
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

thanks for the help
and this is what I get using any options that I have tried

3. ## Re: Using MIN function in column with blanks

I am using Excel 2016

4. ## Re: Using MIN function in column with blanks

Xl 2016 doesn't have MINIFs so use the formula I supplied in post#20

5. ## Re: Using MIN function in column with blanks

You Sir are my new hero as that does work for what I want and now to figure out how to get value in column A corresponding to the result and where to find the answer
Thank you very much for the help and patience with my ability's

6. ## Re: Using MIN function in column with blanks

Glad we could help & thanks for the feedback

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•