Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array functions
=MEDIAN(IF(EJ$2:EJ$5709="dulcer",IF(GJ$2:GJ$5709=0 ,IF(GN$2:GN$5709="",GM$2:GM$5709))))
Entered as an array, the above formula works in giving me the median value that I'm looking for. Also works for aveerage and standard deviation. However, I need quartile values as well. When I substitute "quartile" for "median" and add a "comma,1} following the GM$2:GM$5709 to read: =quartile(IF(EJ$2:EJ$5709="dulcer",IF(GJ$2:GJ$5709 =0,IF(GN$2:GN$5709="",GM$2:GM$5709,1)))) the formula fails with the message that I've entered too few arguments for this function. Can anyone tell me what the problem is? Also 2nd question. If I want to enter multiple text terms or #'s the the column EJ2:EJ5709 i.e. both "dulcer" and "decub" or several #'s like 1, 3 and 7 i.e. if either of those text terms or any of those numbers are present, then include them in the array analysis of median values, how do I do that? I know I drop out the quotation symbol for #'s but not sure how to combine several Thanks anand |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect ref in array formulas | Excel Worksheet Functions | |||
SUMPRODUCT + CSE | Excel Worksheet Functions | |||
Question to Bob Phillips (or whoever...) | Excel Worksheet Functions | |||
Array | Excel Worksheet Functions | |||
array functions and ISNUMBER() | Excel Worksheet Functions |