countifs within a date range

[Kidmon]

Thanx for your help.
On work sheet 2, I am trying to (consolidate?) count "Text" (from wksheet1) within a specific date range. I am having trouble with entering the date information. Referencing the date is warping my mind. I think it looks something like this:

=COUNTIFS(sheet1$D:$D"*text*"),($G:$G date range of 1/1/2011 -1/31/2011)

I know it is simple to the right people.
How can I do this?

 

[VoG]

Try


=COUNTIFS(sheet1$D:$D,"*text*",$G:$G,">="&"1/1/2011"+0,$G$G,"<="&"1/31/2011"+0)

 

[Kidmon]

Thanx, it ALMOST worked. I made a couple of additions to YOUR formula and it worked great. I added (sheet 1) references in 2 places and schazammmmm.

=COUNTIFS('Sheet1s'!$D:$D,"text",'sheet 1'!$G:$G,">="&"1/1/2011"+0,sheet 1'!$G:$G,"<="&"1/31/2011"+0)

Now I need 1 more fix and I am done.
Same counting in date range but I also need to count "text" in 2 colums Any ideas?
Thanx again