this is an array formula so must be entered with ctrl+shift+enter

=AVERAGE(IF(C3:C233,C3:C23))

--
Don Guillett
SalesAid Software

"John Emhof" <John wrote in message
...
I need to determine the average value from a range of values for those
values
in that range that are larger than a certain value. This would act
similiar
to the COUNTIF function, but it doesn't seem to exist.