Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
median excluding 0's
What formula would give the median of a range but exclude all 0's. Thanks!
-- maryj |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
median excluding 0's
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(A10,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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
median excluding 0's
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" wrote in message ... What formula would give the median of a range but exclude all 0's. Thanks! -- maryj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the median of numbers meeting criteria | Excel Discussion (Misc queries) | |||
Subtotal the median | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Find Median of Positive numbers only in Range | Excel Worksheet Functions | |||
Excel's Pivot Table & Subtotal function should have a median fie. | Excel Worksheet Functions |