Use a Pivot Table. It will allow you to group the date field by year and month
(Be sure to do both. You don't want Jan 2003 and Jan 2004 to be added
together).

On Mon, 31 Jan 2005 20:37:03 -0800, HiDbLevel
wrote:

I use Excel to maintain crime statistics. I would like to use the COUNTIF
function (or whatever works) to count a crime by month. I have the crimes in
column A and the date in column B. Basically what I am trying to do for
example is count all of the thefts in January. I know how to count all
thefts, but that will give me all of the thefts for that year, not just the
ones that happened in January and in the same I know how to count all the
crimes in January, but not just the thefts that occured in January. Any
thoughts?