median excluding 0's

What formula would give the median of a range but exclude all 0's. Thanks!
--
maryj

I can't think of a direct way to do it.

Let's say your numbers are in Column A, then in B1 you would place the
following formula:
=IF(A1>0,A1,"")

Then drag it down for all numbers in column A. Then you can use
=MEDIAN(B:B) to return the median while excluding zeros

"maryj" wrote:

> What formula would give the median of a range but exclude all 0's. Thanks!
> --
> maryj

One way

=MEDIAN(IF(A1:A50<>0,A1:A50))

it's an array formula and needs to be entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom

Portland, Oregon




"maryj" <maryj@discussions.microsoft.com> wrote in message
news:59A787D6-FF64-445B-B2A6-99C000FA2131@microsoft.com...
> What formula would give the median of a range but exclude all 0's. Thanks!
> --
> maryj