defining a range subset based on a primary range for use in Median and Mode functions

I'm new here, so I hope I'm folloing the proper protocols.

My probelm is this: I have a "master range" ( a single column, Say A22 to A 250 - A22:A250), sorted highest value to lowest value and I want to run median and mode functions. All cells in the master range are results of other calculations. I would like to run Median and Mode functions on the column for only those cells having a value greater than 1000. Depending on the time of day, any particulare cell may go from 0 to 1500.

Ergo, I'd like to be able to say " from this master range of A22:A250 give me the median of ( or for) ony those cells whose current value is greater that 1000 ( the "subset range").

Thanks in advance, Araise

Try these array formulas**:

=MEDIAN(IF(A22:A250>1000,A22:A250))

=MODE(IF(A22:A250>1000,A22:A250))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.