=quartile(IF(EJ$2:EJ$5709="dulcer",IF(GJ$2:GJ$5709 =0,IF(GN$2:GN$5709="",GM$2:GM$5709,1))))

should be

=quartile(IF(EJ$2:EJ$5709="dulcer",IF(GJ$2:GJ$5709 =0,IF(GN$2:GN$5709="",GM$2:GM$5709))),1)

--
Cheers,
Shane Devenshire


"anand" wrote:

=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