median

The following formula works fine... =COUNTIFS(R30:DH30,">"&(MEDIAN(R30:DH30))) This formula works fine as long as you Ctrl+Shift+Enter =COUNTIFS(R2:DH2,">"&MEDIAN(IF((R2:DH2>0),R2:DH2))) The formula below doesn't error out but it reports zero (this is not true when you look at the data). How...

How do I find medians from a frequency distribution table? So I have a table that looks roughly like this: values: 6 5 4 3 2 1 group1: 1 3 0 0 5 1 group2: 3 4 7 0 0 0 group3: 0 0 1 3 4 2 Where the numbers in the group rows indicate how many people selected each value in...

I have a report, posted below, that gives different information about students. Here is a sample. Excel WorkbookABCDEFGHIJK1Fund NameStatusActual AmtData ValidDependency StatusTfcFund Family 2Tot AidResidentcyStudent TypeHousing2PELL GRANTA3200YD2302NPC Grant12015RF13DL SUBA4500YD2302NPC...

Hi: I've been using Excel 2007 and an add-in from Digdb that allows me to calculate medians within filtered tables, since that is not one of the options currently available within Excel (on the total line at the end of the table). Now that Microsoft has released Excel 2011, I'm hoping to...

I am trying to make an array formula for a pivot table that works with lots of filters. I'm using Excel 2007, and have had no luck. I'm using 5 report filters, multiple row labels, and a Count for the values. I have Year, Month, and unique labels for the rows, and a count of those as the...

I've never asked a question on here before but have benefitted from many answers posted to other users questions - so thank you all for that. :) I can't however, find an answer to this one. I have a list of 30 numbers (all +ve integers or zero) that changes every day. I want to ignore the...

I have 3 columns. Thousands of stock tickers, their corresponding free cash flow yields, and their price to economic book values. I have one cell in which I need to find the median free cash flow yield for all tickers with price to economic book values greater than 1. Thanks for the help...