Countif with two different conditions

[Guest]

Hello,
I have a table like below displayed. What I want is to count the no. of
"GIN'S" for any particular date say for the date of "14/05/2006" / for the
month of "05/2006". The answer would have been 6/10.
GIN Nos. DATE ITEM QTY DATE STMP MONTH
GR702430 14/05/06 ATM0541 54 14/05/2006 08:03:46 AM 05/2006
GR702430 14/05/06 MTM1044 54 14/05/2006 08:03:46 AM 05/2006
GR702431 14/05/06 PTM0748 39 14/05/2006 08:07:13 AM 05/2006
GR702432 14/05/06 ATM0093 78 14/05/2006 08:12:06 AM 05/2006
GR702432 14/05/06 MTM0161 144 14/05/2006 08:12:06 AM 05/2006
GR702433 14/05/06 MTM1050 12 14/05/2006 08:14:39 AM 05/2006
GR702434 14/05/06 ATM0541 54 14/05/2006 08:51:42 AM 05/2006
GR702434 14/05/06 ATM0543 54 14/05/2006 08:51:42 AM 05/2006
GR702435 14/05/06 ATM0549 54 14/05/2006 08:54:52 AM 05/2006
GR702435 14/05/06 ATM0556 54 14/05/2006 08:54:52 AM 05/2006
Help in this regard will be highly appreciated.

 

[Bob Phillips]

=SUMPRODUCT(--(INT(E2:E15)=--"2006-05-14"))

=COUNTIF(H:H,"05/2006")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)