Oops, seeing the other guys post I see you are using US dates. My formula
should thus be

=MEDIAN(IF(MONTH(A1:A20)=11,B1:B20))

still an array formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
=MEDIAN(IF(DAY(A1:A20)=11,B1:B20))

as an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kraway" wrote in message
...
I have 2 columns in a spreadsheet. Column A contains a date in format
11/30/2005. Column B contains a number. I need an If statement that
will
return the median value of column B where the date in column A begins
with
11.

Any thoughts appreciated!