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