On Thu, 23 Jun 2005 17:23:11 -0700, "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
Will there be 0's?
With no 0's, then the **array** formula:
=MEDIAN(IF(rng0,rng))
for positive numbers and
=MEDIAN(IF(rng<0,rng))
for negative numbers.
To enter an array formula, hold down <ctrl<shift while hitting <enter.
Excel will place braces {...} around the formula.
If 0's will be included as positive numbers, then something like:
=MEDIAN(IF((rng=0)*(rng<""),rng))
(also array-entered) should do the trick.
--ron
|