View Single Post
  #2   Report Post  
Old April 12th 19, 07:08 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,696
Default How do I Find The MEDIAN IF My Formula Meets Criteria in Excel


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.

=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.

Claus B.
Office 2016