=SUMPRODUCT(--(A1:A1000=--"2005-03-08"),--(B1:B1000="type1"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry" wrote in message
...
I have a spreadsheet that lists thousands of items with
one column being a date field. I would like Excel to
count for me how many entries there are by date and type.
Any suggestions?