Multiple COUNTIF and MONTH

[kerlj001]

I need some help with an excel formula pleas:

=SUMPRODUCT(--(RAW!$R$3:$R$20000="RESPOND"),--(RAW!$I$3:$I$20000=B4),--( RA W!$S$3:$S$20000="MADE"))


which searches the RAW tab and counts the number of rows where all 3 arrays are met. This works fine.

I need to now added another array to search column T (Dates dd/mm/yyyy) for all the above AND where the /mm/ part of the date = 12 (for example)

I tried this but n luck
=SUMPRODUCT(--(RAW!$R$3:$R$20000="RESPOND"),--(RAW!$I$3:$I$20000=B3),--( RA W!$S$3:$S$20000="MADE"),--(MONTH(RAW!$Q$3:$Q$20000=12)))


Any Ideas please, its driving me mad!

Thnx, Jody

 

[kerlj001]

<table width="73" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <tbody><tr style="mso-height-source:userset;height:12.75pt" height="17"> <td class="xl64" style="height:12.75pt;width:55pt" height="17" width="73">6/17/2011</td> </tr> <tr style="mso-height-source:userset;height:12.75pt" height="17"> <td class="xl64" style="height:12.75pt;border-top:none" height="17">6/18/2011</td> </tr> <tr style="mso-height-source:userset;height:12.75pt" height="17"> <td class="xl64" style="height:12.75pt;border-top:none" height="17">6/19/2011</td> </tr> <tr style="mso-height-source:userset;height:12.75pt" height="17"> <td class="xl64" style="height:12.75pt;border-top:none" height="17">6/20/2011</td> </tr> <tr style="mso-height-source:userset;height:12.75pt" height="17"> <td class="xl64" style="height:12.75pt;border-top:none" height="17">6/21/2011</td> </tr> <tr style="mso-height-source:userset;height:12.75pt" height="17"> <td class="xl64" style="height:12.75pt;border-top:none" height="17">6/22/2011</td> </tr> <tr style="mso-height-source:userset;height:12.75pt" height="17"> <td class="xl64" style="height:12.75pt;border-top:none" height="17">6/23/2011</td> </tr> </tbody></table>

 

[kerlj001]

Although the inputbox shows 17/6/2011?