Track Data in one column by date in another column using date ranges

In column "B" I have text data (workers initials. ie. "RS", "WF" and "HA"). These all have a date after them in column "C" (certification dates ie. 1/1/2013). I am trying to set up a spread sheet to tell me how many certifications "RS" has done in the month of January but can't seem to get a formula to do what I need. I am able to get a countif formula to count how many dates there are in column "C" between a date range using:

=COUNTIF(KettleCheck!$C$4:$C$1000,">="&DATE(2013,1,1))-COUNTIF(KettleCheck!$C$4:$C$1000,">="&DATE(2013,1,32))

Thanks for your help in advance!

Re: Track Data in one column by date in another column using date ranges

Will this formula also account for the year as well? I have dates ranging from the year 2010 to 2013 and I only need to track the dates in 2013.

Re: Track Data in one column by date in another column using date ranges

I actually did try to do a pivot table but it did not work. I am not sure if I am trying to set the table up wrong but to be honest I have never actually used one before either.

Re: Track Data in one column by date in another column using date ranges

I have figured it out! Using Dangle's original formula I added on to that to account for the year as well as the month.

=SUMPRODUCT(--(KettleCheck!$B$4:$B$1000="RS"),--(MONTH(KettleCheck!$C$4:$C$1000)=1),--(YEAR(KettleCheck!$C$4:$C$1000)=2013))

It seems to be working and I am coming out with the correct data as if I had done it by hand. Thank you for all your help!