Counting Dates

J

Jerry

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?
 
B

Bob Phillips

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

--

HTH

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