Words and dates...

  • Thread starter Thread starter m4d Ir15h
  • Start date Start date
M

m4d Ir15h

Someone very helpful helped me with a formula and hope maybe they can help me
once agian.

they gave me the following formula, which searched for text within a column.
What do I need to do to adjust that to choose specific text within certain
dates...

=COUNTIF(C:C,"RXL")

it works great... but I came up with the problem of needing only the Rxl's
between certain dates. This formula calculates them all.
 
Let's assume that the dates are in column B. Try this:

=SUMPRODUCT(--(B1:B100>DATE(2007,1,1)),--(B1:B100<DATE(2008,1,1)),--(ISNUMBER(SEARCH("RXL",C1:C100))))

This will give youdates between 1/1/2007 and 1/1/2008 that contain RXL in
column C.
 
Back
Top