F
FUNACH
need to average lowest 6 out of 10 cells?
Jacob Skaria said:With your values in A1 to A10. Try and feedback
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))
If this post helps click Yes
Jacob Skaria said:With your values in A1 to A10. Try and feedback
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))
If this post helps click Yes