Words and dates...

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.
 
B

Barb Reinhardt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Words ... yay ... letters .... blech! 3
Excel Formula - Count Dates from another Sheet 8
Excel Dragging countif formula with changing criteria 3
Excel Sumproduct 0
Adding dates in columns 2
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Formulas not working in Microsoft Excel 2007 table 1
help with a formula please 7

Top