Does anyone know what formula I enter to perform the following function?

If a cell in a row contains an entry such as "R1 Live" and a second cell in
a row contains one of a range of dates in the form of 12/2010 , then the cell
result = date in the column of "R1 Live".
--
thanks

Hi,

12/2010 is not a legal Excel date.

=SUMPRODUCT(--(A1:A100=DATE(2010,12,1)),--(A1:A100<=DATE(2010,12,31),--(B1:B100="R1 Live"),A1:A100)

This is only resonable if there is only one line that meets these conditions.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"digit" wrote:

Does anyone know what formula I enter to perform the following function?

If a cell in a row contains an entry such as "R1 Live" and a second cell in
a row contains one of a range of dates in the form of 12/2010 , then the cell
result = date in the column of "R1 Live".
--
thanks

Assumes col G is really a proper date formatted as mm/yyyy

=SUMPRODUCT(($FR$14:$F$15="r1
live")*(TEXT($G$14:$G$15,"mm/yyyy")="12/2009"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"digit" wrote in message
...
Does anyone know what formula I enter to perform the following function?

If a cell in a row contains an entry such as "R1 Live" and a second cell
in
a row contains one of a range of dates in the form of 12/2010 , then the
cell
result = date in the column of "R1 Live".
--
thanks