This formula works for me:

=SUMPRODUCT(--(A1:A20<upper),--(A1:A20lower),(A1:A20))/SUMPRODUCT(--
(A1:A20<upper),--(A1:A20lower))

upper is a named range that is the mean of all the data plus the
standard deviation of all the data and lower is the mean minus one
standard deviation. The data is in A1:A20.

Ken

On Aug 6, 8:25*am, AHartong (donotspam)
wrote:
I'm trying to find the average of a range of cells that exclude points
outside the standard deviation of the cells. I found the standard deviation
and made simple conditional format (cells outside STDEV are in red) rules on
the cells outside of the range, but I'm not sure how to find the average
excluding the formatted cells.