median excluding 0's
What formula would give the median of a range but exclude all 0's. Thanks!
-- maryj |
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 |
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 |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com