need to average lowest 6 out of 10 cells?
J Jacob Skaria May 18, 2009 #2 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
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
F FUNACH May 18, 2009 #3 yes, i luv u, thanks so much! 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 Click to expand...
yes, i luv u, thanks so much! 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 Click to expand...
