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.
--
Vikram Dhemare

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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Vicky" <(E-Mail Removed)> wrote in message
news:CE333E97-38FD-4B41-8FFA-(E-Mail Removed)...
> 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.
> --
> Vikram Dhemare