Help needed for Formula that counts based on Date & 3 criteria

[sellim]

Hi, I have been using the following formula to count the number of occurrences of "text1" in a specific data range during a specific date range (1-oct-2012 to 7-oct-12):
=SUMPRODUCT(--(J6:J100="text1"),--(!D6:D100>=--"2012-10-01"),--(!D6:D100<=--"2012-10-07"))

J6:J100 is the data range. D6:D100 is the date range.

This formula works great.

I would like to however also count for "text2".

So I would like to look in the data range J6:J100 and count the number of times that "text1" and "text2" come up over the period 1-oct-2012 to 7 - oct- 2012.

this is my first post so i hope i have been clear. I would be very greatful to anyone who can help me!
Thanks in advance for any hints or the actual solution

[Ace_XL]

Try..

SUMPRODUCT((J6:J100={"text1","text2"})*(D6:D100>="2012-10-01")*(!D6:D100<="2012-10-07"))