Is there a medianif similar to averageif
 

I need to calculate the median for a day of the week over an entire year. It
is possible to do this with averageif but is there something similar
calculating the median?

Answer: Is there a medianif similar to averageif
 

Yes, there is a way to calculate the median for a day of the week over an entire year using a similar function to AVERAGEIF. The function you are looking for is called MEDIANIF.

1. First, make sure your data is organized in a table with columns for the day of the week and the corresponding data for each day.
2. Next, determine the criteria for which you want to calculate the median. In this case, it would be the day of the week.
3. In a new cell, enter the
   Formula:

   ---

   MEDIANIF 


   ---

   function. The syntax for MEDIANIF is:
   
   
   Formula:

   ---

   MEDIANIF(range, criteria, [median_range]) 


   ---

   
   
   - Range: This is the range of cells you want to evaluate for the criteria.
   - Criteria: This is the criteria you want to use to determine which cells to include in the median calculation. In this case, it would be the day of the week.
   - Median_range: This is the range of cells you want to use to calculate the median. In this case, it would be the corresponding data for each day.
   
4. For the range argument, select the entire range of cells that includes both the day of the week and the corresponding data.
5. For the criteria argument, enter the day of the week you want to calculate the median for. For example, if you want to calculate the median for Mondays, enter "Monday" in quotes.
6. For the median_range argument, select the range of cells that includes the corresponding data for each day.
7. Press enter to calculate the median for the specified day of the week.
8. Repeat steps 3-7 for each day of the week to calculate the median for the entire year.

Is there a medianif similar to averageif
 

Hi:

There isn't a median if, to the best of my knowledge.

But have a look here
http://www.bettersolutions.com/excel...N622911811.htm
where Russell Proctor has written a very nice user defined function.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"justnike4" wrote:

I need to calculate the median for a day of the week over an entire year. It
is possible to do this with averageif but is there something similar
calculating the median?

Is there a medianif similar to averageif
 

With worksheetfunctions, Array enter (using Ctrl-Shift-Enter) a formula
like:

=MEDIAN(IF($B$2:$B$200=E2,$C$2*:$C$200))

That will return the median of numbers in C2:C200 where B2:B200 matched cell
E2.

HTH,
Bernie
MS Excel MVP

"justnike4" wrote in message
...
I need to calculate the median for a day of the week over an entire year.
It
is possible to do this with averageif but is there something similar
calculating the median?

Is there a medianif similar to averageif
 

On Thu, 10 Apr 2008 17:02:01 -0700, justnike4
wrote:

I need to calculate the median for a day of the week over an entire year. It
is possible to do this with averageif but is there something similar
calculating the median?

No MEDIANIF. However, you could use an array formula similar to this,
depending on your precise specifications:

=MEDIAN(IF(WEEKDAY(B1:B365)=2,A1:A365))

After you make the appropriate changes in the references, enter the formula by
holding down <ctrl<shift while you hit <enter. Excel will place braces
{...} around the formula.
--ron