Dave_MoyseCopper ContributorSep 21, 2020Help with a calculation I need a formula to calculate the average of the lowest 8 of 20 numbers. E.g. 2, 4, 6, 8, 3, 11, 9, 8, 3, 10, 2, 4, 6, 8, 3, 11, 9, 8, 3, 10, Answer is 3
SergeiBaklanDiamond ContributorSep 21, 2020Dave_Moyse That could be =AVERAGEIF(A1:A20,"<=" & SMALL(A1:A20,8)) if numbers are in A1:A20
