Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 12th 19, 06:41 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2019
Posts: 1
Default 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   Report Post  
Old April 12th 19, 07:08 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,660
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find cell address that meets the criteria tkraju via OfficeKB.com Excel Discussion (Misc queries) 5 February 5th 07 01:12 PM
find date that meets a criteria TUNGANA KURMA RAJU Excel Discussion (Misc queries) 9 November 21st 06 07:08 PM
find date that meets a criteria tkraju via OfficeKB.com Excel Discussion (Misc queries) 3 November 18th 06 04:15 PM
In an array, I need to find the row # that meets 2 criteria Space Elf Excel Worksheet Functions 1 March 8th 06 03:55 PM
formula that meets two criteria and sums? C Cooper Midland Excel Discussion (Misc queries) 2 December 14th 04 02:49 PM


All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017