median

  1. S

    Trying to Calculate Median, Ave, Percentile provided an INPUTed date range

    Hi, I am working on a project and have not figured out one aspect: I have daily data that lists the number of rooms occupied through the morning. I wanted to make a dynamic calculation (calculate the Median or percentile, etc) over a specified time period. I.E. I would input a “date range”...
  2. B

    Calculate median sale by month and year

    Hey everyone! I am working with a large set of real estate sales data (nearly 38,000 records). It spans from January 1, 2008 until March 31, 2014. I am trying to figure out a way to get the median price for each month and year. So I am looking for 75 median figures (6 years, 3 months). We...
  3. M

    Median using if/and statement

    I just can't figure out why my median formula isn't working. I am trying to get the median annual return, based on "groupings" of distances. For example, since A2:A5 are <= 50 miles and are also > 0, I want Excel to give me the median annual return for B2:B5 (which is 0.27). Help! Excel 2012...
  4. M

    How to calculate the Median from a cell with varying amounts of numbers separated by commas?

    Hello In essence what I need is very simple but I cannot find an answer anywhere online. I have a long string of numbers of variable length (sales in a week) in a format where another number simply gets added to the string each week. I think I am right in saying I want to be able to find out...
  5. I

    Need help with new project...

    Looking for ideas on how to combat a new task. Raw Data: Column 1: Date Column 2: Folio # (Reservation #) Column 3: Price Eg. 1/1/14 65451 $60.00 1/1/14 54874 $60.00 1/1/14 78451 $70.00 1/1/14 45612 $60.00 1/2/14 87451 $80.00 1/2/14 98745 $70.00 1/2/14 12346 $80.00 1/2/14 65497 $80.00 etc...
  6. M

    Calculate the median days between events

    Thanks to Barry Houdini I was able to calculate the average days between events in a table. I have a sales table with fields for salesperson ID, Sales Date, Sale Amount. Each person can have one or many sales in the table. I am trying to calculate the median days between sales for each sales...
  7. S

    Medians and context issues in DAX

    I am having an issue that I am hoping some more experienced DAX programmers may be able to help me with. This problem is cross-posted on StackOverflow here (excel - Medians and slicers in DAX - Stack Overflow) with no answers so far. I have been trying to develop a dashboard in Excel 2013 /...
  8. S

    Struggling with MEDIANIF, get #NUM!

    On Excel for Mac 2011 I have a median if array (am using C-S-E) that works for about 5 of my criteria, but when I add in my last criteria, it goes to #NUM!. I know I am missing something basic, and that #NUM! is a clue for where I am going wrong, but can't figure it out... So I have for...
  9. D

    Clarify the way MEDIAN works

    Hi I wish to calculate the median of a column of numbers where the number is greater than zero. Sometimes there will be text in the column and I want those to be ignored. Reading the help documentation for Excel 2007 it states: "Arguments that are error values or text that cannot be...
  10. S

    How put OR into multiconditional SUMIFS (and AVERAGEIFS, MEDIAN)?

    I think I could do a simple sum of these two: =SUMIFS(A1:A10,B1:B10,"="&"Red",C1:C10,"="&"2013") =SUMIFS(A1:A10,B1:B10,"="&"Blue",C1:C10,"="&"2013") But wondering if there is a way to embed the OR into the SUMIFS. Like (I can't get this to work though..)...
  11. S

    Need help w/multiconditional MEDIANIFS and AVERAGEIFS

    Hello all- Struggling with multiconditional statements trying to find a median and average. Even trying to calc with just one condition isn't giving the right answer. Folks here just helped me with a COUNTIF (thanks again!) and now I'm trying to take the next step but flailing... Trying to find...
  12. C

    median in access query

    hi, I am trying to calculate the median in an access query. I tried various forums and I can never get it to work... I created a table called: "Ages" In the table called "Ages", I have one column called "Names" and it contains a couple of names. I also have one column called "Age". I...
  13. P

    Calc for MEDIAN on a Diagonal

    I am working with an array formula that SUM's on the diagonal.. =(SUM((COLUMN($H$7:$HU$228)-ROW($H$7:$HU$228)=((INDIRECT(H2))-($G$6)))*$H$7:$HU$228)),0) it is part of a matrix i am using and I need to get this formula to work with MEDIAN rather than sum... actually I need this formula to work...
  14. O

    Show a result based on numbers that match a scale

    Hi, this should be really easy but im stumped. A1 needs to show "0.95%", or "0.8%", and so on, based on a figure entered into A2. Doesnt need to calculate the percentage out or anything, just return a figure based on A2 being within a certain range. Im confused by IF and AND and cant get that...
  15. O

    subtotal median

    we've got a excel sheet populated with column ROA and firm year, there's over 10000+rows of data and we have already sorted the data according to the firm year but now we want to get the median ROA for each year. and the subtotal function only have ave, is there a way aotomatically group the...
  16. S

    Median Test

    Greetings: I am trying to build-up a formula to perform a median test (e.g., chi square) on a set of data. There are a number of conditions that need to be applied when looking up the data that is complicating the formula. Below is a subset of the data in my worksheet. I'm using two tables...
  17. K

    Find Median value in an array

    Hi, I have an unsorted column of values which range between 0 and 100. Using VBA formula i need to return the median (in terms of sorted position) value. An added complexity is that i only wish to look at values in the range (column) which meet criteria against another column. e.g consider the...
  18. D

    Calculating Median's with Multiple Conditions

    Hi: Quick issue I'm hoping someone can help me with. Since the Pivot function lacks a median calculation, I need to calculate some median's based off three conditions in a data sheet. I found working formulas for 2 conditions, but not three. Here is what the data like: A B...
  19. B

    monthly median based on daily values

    Hey guys, I would like to find the monthly median price of daily transactions. For an average I can use a pivot table, but it does not have the median function build in. I have calculated the daily median value using an array formula...
  20. B

    Median based on criteria of another cell

    {=MEDIAN(IF('textexport(2)'!J:J>0,'textexport(2)'!F:F))} I keep receiving 0 when using this formula. I want to take the median of values in column F if the corresponding values in colum J are above 0. Any ideas why this does not work.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top