How can I count and sum entries per date?

Hello,

I have a worked listing items per date, ie

11-1-2011 hot
11-1-2011 cold
11-1-2011 hot
11-1-2011 warm
11-2-2011 hot
11-3-2011 something
11-3-2011 cold
11-3-2011 red

How can I count the number of entries for each date, so a result like:

11-1-2011 4
11-2-2011 1
11-3-2011 3

Thank you!

I you have your list of unique date values starting at say, C2, then in say D2 enter:

=COUNTIF(A:A,C2) copied down

where A:A represents column A and contains your original list of dates.

You have to first create a list of unique dates.

If you have dates that are cumulatively ascending by 1 day, then try entering the first date in a new column, say C2, then copy that date down it should increment by 1 day, then you can apply formula.

Or you can select column A, and go to Data|Filter|Advanced Filter and select Unique Values Only, select a location like C2 and click Ok. This should give a unique list of dates, then apply formula to this list...

or you can create a Pivot Table like attached which does all the work for you.