Sometimes I have a list of values and want to average them, while excluding zeros or negative numbers, so I use the following popular array formula. "MyRange" is a named range of cells on a worksheet. I discourage the use of magic numbers, but they are included below for visual reference.
Feel free to use cell references instead.

Continue Reading: Average Values, Exclude Extremes »