Median fuction
Posted by Carmen on November 28, 2000 9:19 AM
Hi, I am wondering if somebody knows a simple formula
to do a "medianif"? I know there is "sumif" and
"countif" and I am looking for something similar when
calculating the median (or average, etc.)
Posted by Loren on November 28, 2000 10:56 AM
average function
Use sumif/countif for averaging
Posted by Tim Francis-Wright on November 28, 2000 11:06 AM
You can use an array formula (use control-shift-enter instead of enter when inputting it):
for example,
=MEDIAN(IF(YourRange>0,YourRange))
will give the median of all of the positive values
in YourRange.
HTH
