median if

I'm struggling to take a median of a set of data with multiple criteria I have a set of raw data (Shown Below) I want to find the Median of the data in Row K (Gain) for all the cells where the DEF Call (Row H) is "Base Tommy" AND it's in Hole (Row R) 2 OR 3 OR 4 OR 5. (I don't want the median...

Hello everyone, I was wondering if it would be possible to select a random number from an existing list based on criteria and having the return "random number" be within a range defined by the median (15% above and below the median). Customer No. Amount 123 $50 123 $300 234 $70 456...

I am trying to calculate a median based on several criteria. The formula works fine when the criteria are all met, but when they are not I get #NUM !. I would rather it returned a blank or a 0. Here's the formula I'm using...

I need to write a formula that calculates a median value, with several IF clauses. EG 'data' tab is below: <tbody> Person Sales Margin Tommy 2 100 Jimmy 3 300 Henry 5 500 Jimmy 4 200 Jimmy 6 100 Tommy 10 200 Henry 3 700 Henry 5 1000 Tommy 7 500 </tbody> In another tab, I...

I am trying to take the median of a range of values, filtered by the number in the limit column. As small subset of the data is below. For example, I need to write a function that finds the median of all the values for records with a Limit of 500. In this subset of data the function should...

Hello, I am trying to use one array formula to recreate the following linear regression formula: Y = (SalesRatio-MedianSalesRatio)/MedianSalesRatio X = LN(((EMV/MedianSalesRatio)⁄(2))+ (SalePrice⁄(2)))/LN(2) Here is my data: <tbody> <tbody> SalePrice </tbody> <tbody>...

Hello, I have a large set of data. I am trying to calculate the median (and other percentiles) of a range of data conditional upon a number of factors. So, i have: A range of salaries - this is what i want the median of but only when certain conditions are met. Conditions: - Location -...

Hello all, I apologize but I cannot download the html creator while at work due to IT locking that function down so hopefully I can describe my question in a way that makes sense. I am trying to create a formula that checks if a single cell date falls between a beginning and end date using the...

I need to find the median of data based on several pieces of criteria. I have found that Median can be use with IF as an array formula, but i can't find anything to say that I can use several pieces of critera from various columns on the IF Can I use Median(if(and(...,....,...,))) as an...