If you really mean OR, so if answering the first half of your question is
OK:

=(SUM(YourRange)-MIN(YourRange))/(COUNT(YourRange)-1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"TNTraining" wrote in message
...
I need to get an average of a set of numbers and either exclude the lowest
number in the set OR make sure that only numbers over 10,000 are in the
average -- does anyone know how to do this?