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?