Oct 21 2021 01:21 PM
Hello,
I am trying to figure out why this formula is not working on this sheet.
=sum(small(y4:y8,row(indirect("1.4"))))
I need to get the formula to work on this template. Or am I completely wrong on the formula? Any help is greatly appreciated!!!
10 Best Lowest Net |
10 Best Putt |
4 Lowest Net on Low Net Day |
Oct 21 2021 03:52 PM
Depends on Excel version, idea of the formula could be
=SUM( SMALL( FILTER(D4:D24, D4:D24 > 0 ), SEQUENCE(10) ) )
Logic is also not clear, at least for me - what is Low Net Day, shall we calculate requested by column, by front and back, by entire data set.
Oct 22 2021 08:59 AM
Good morning,
Thank you for your reply.
On C28 I used =AVERAGEIF(Y4:Y24,"<>0") to not include the 0 in the average
The formula is to only count the 10 lowest scores. See formula below. Do you know the formula is to exclude zero's?
=SUM(SMALL(Y4:Y24,ROW(INDIRECT("1:10")))) Cell AC2
I appreciate your help!
Oct 22 2021 01:14 PM
SolutionFor your variant of formula that could be
=SUM( SMALL( Y4:Y24, COUNTIF( Y4:Y24, 0 ) + ROW( INDIRECT( "1:10" ) ) ) )
Oct 26 2021 09:59 AM
Oct 22 2021 01:14 PM
SolutionFor your variant of formula that could be
=SUM( SMALL( Y4:Y24, COUNTIF( Y4:Y24, 0 ) + ROW( INDIRECT( "1:10" ) ) ) )