The below formula will return the average after ignoring the largest numbers
from row 1. The number of cells to be ignored is to be specified in cell B3.
Try and feedback...

=(SUM(1:1)-SUMPRODUCT(LARGE(1:1,ROW(INDIRECT("1:"&B3)))))/(COUNT(1:1)-B3)

If this post helps click Yes
---------------
Jacob Skaria


"sailor" wrote:

I have a series of numbers in a row with text in some cells and blanks in
others. How can I throw out the largest one, two or three numbers and
average the remaining? The total number of cells to be thrown-out will be a
variable from row to row.