Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I Find The MEDIAN IF My Formula Meets Criteria in Excel
Hello,
Can anyone show me how to write a formula that will find the MEDIAN of a group of numbers in one column related to specific criteria in another column? My business segment name data is located in column T and my days open numbers are located in column U. Below is the formula I've written thus far but I can't get it to work: =MEDIAN(IF(QTR1_TA_TaleoData!$T$4:$T$170=QTR1_TA_T aleoData!$T$4:$T$170,"IOS",QTR1_TA_TaleoData!$U$4: $U$170)) Below is what I want the formula to do: Look at the range $T$4:$T$170 on the QTR1_TA_TaleoData spreadsheet and find only those cells that contain a business segment name of IOS; once all the IOS business segment cells have been found, then tell me what the MEDIAN is for the numbers located in range $U$4:$U$170 on the QTR1_TA_TaleoData) spreadsheet for the IOS business segment. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Find The MEDIAN IF My Formula Meets Criteria in Excel
Hi,
Am Fri, 12 Apr 2019 18:41:36 +0100 schrieb znxm0i: Look at the range $T$4:$T$170 on the QTR1_TA_TaleoData spreadsheet and find only those cells that contain a business segment name of IOS; once all the IOS business segment cells have been found, then tell me what the MEDIAN is for the numbers located in range $U$4:$U$170 on the QTR1_TA_TaleoData) spreadsheet for the IOS business segment. try: =MEDIAN(IF(QTR1_TA_TaleoData!$T$4:$T$170="IOS",QTR 1_TA_TaleoData!$U$4:$U$170)) and insert that formula with CRTL+Shift+Enter. Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find cell address that meets the criteria | Excel Discussion (Misc queries) | |||
find date that meets a criteria | Excel Discussion (Misc queries) | |||
find date that meets a criteria | Excel Discussion (Misc queries) | |||
In an array, I need to find the row # that meets 2 criteria | Excel Worksheet Functions | |||
formula that meets two criteria and sums? | Excel Discussion (Misc queries) |