excel formula

  • Thread starter Thread starter digit
  • Start date Start date
D

digit

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".
 
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.
 
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"))
 
Back
Top