Median or mean? Median for Jan.:

=MEDIAN(IF(C1:C100=1,A1:A100))

Array-entered, meaning press ctr/shift/enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

I have a file with data and some months on, the months
are as numbers, e.g. jan =1 , feb =2, . I would like to
be able to calcule the mean values based on data in col
a by month in col c. It would be good if i could have
just one formula that looks at the records in col c and
if it is say 1, than looks at the value in col and then
returns the median ov all records where colc is 1, then I
could do the same for the other months.

Hope this makes sense,

Cheers

Daniel
.