Forum Discussion

Cliff Fox's avatar
Cliff Fox
Copper Contributor
Jan 18, 2017
Solved

Formula no longer working

Note: The link below has been corrected:   The formula in column U is only supposed to produce a result if 5 or more scores have been inserted. It was given to me in this forum, and adds the lowest...
Formulas & Functions
Need Help
  • Jamil's avatar
    Jamil
    Jan 19, 2017

    Hi Cliff Fox,

     

    please put this formula in U3 and enter with Control + Shift + Enter then drag it down.

     

    =IF(V3<5,"",SUM(SMALL(IF((SUBTOTAL(2,OFFSET(S3,,,1,(COLUMN($B3:$S3)-COLUMN(T3))))<=U$1)*($B3:$S3)=0,FALSE,(SUBTOTAL(2,OFFSET(S3,,,1,(COLUMN($B3:$S3)-COLUMN(T3))))<=U$1)*($B3:$S3)),{1,2,3})))

    this will work, if the scores are lower than 5 it will result blank.

     

    BTW:  it looks like the column headers in row 2 are names of Afghan Calendar months :-)

Daniel Colardelle's avatar
Daniel Colardelle
Copper Contributor
Jan 18, 2017

Hi. There is a problem with your link.

Daniel

Resources