Page 3 of 3 FirstFirst 123
Results 21 to 26 of 26

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

  1. #21
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #22
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #23
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using MIN function in column with blanks

    I am using Excel 2016

  4. #24
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,123
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Using MIN function in column with blanks

    Xl 2016 doesn't have MINIFs so use the formula I supplied in post#20
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #25
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #26
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,123
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Using MIN function in column with blanks

    Glad we could help & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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