I have 20 input values and i only want to calculate the average of the 10 lowest numbers. the values range from cells b3:u3.
Thanks
Kennyg350
I have 20 input values and i only want to calculate the average of the 10 lowest numbers. the values range from cells b3:u3.
Thanks
Kennyg350
Try this array and let me know if it works:
=AVERAGE(IF(B3:U3<=SMALL(B3:U3,10),B3:U3))
Note: This is an array formula. Confirm with CTRL+SHIFT+ENTER, not just ENTER
Worked Perfect Thank You Very Much!!!
Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks