"MichaelC" wrote:

I have a column containing both positive and negative numbers
I need a formula to find the Median of all positive numbers, and a separate
formula to find the Median of all negative numbers
Any help gratefully acknowledged

The following are array formulas entered with cntrl+shft+enter

=MEDIAN(IF(B2:B130,B2:B13))
=MEDIAN(IF(B2:B13<0,B2:B13))

Peter atherton