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!

HI,
Try:
=IF(MONTH(A1)=11,your formula,"")

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=489397

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

I need to find all values in column A that begin with 11 not just row 1.
There will be several rows selected and I need the median value of column B
for all rows selected.

"pinmaster" wrote:


HI,
Try:
=IF(MONTH(A1)=11,your formula,"")

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=489397

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!

Thank you Bob, this looks like it will work. What is meant by "commit with
Ctrl-Shift-Enter"

"Bob Phillips" wrote:

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!

It means that after you type in the formula, don't hit the Enter key, use
the Ctrl-Shift-Enter keys all together. The formula will then appear in the
formula bar like so

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

Excel puts in the braces.

--

HTH

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


"kraway" wrote in message
...
Thank you Bob, this looks like it will work. What is meant by "commit
with
Ctrl-Shift-Enter"

"Bob Phillips" wrote:

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!