using countif to add dates

J

jwmillzy

I need to count the number of events in a month.
I am reading off a column of cells that have 5/1/2006,
5/11/2006, 4/27/2006, etc
I want to tally the number of events, so in the above example
the result would be May 2 and April 1
I need it to count all dates in may as one total, April as a total etc
I am having trouble because my formula will only recognize each unique date
Any suggestions, thx
 
S

SteveG

You could use SUMPRODUCT


If A1:A10 is your range of dates then,


=SUMPRODUCT(--(MONTH(A1:A10)=5))

The 5 in the formula represents the month number 1 for Jan 2 for Feb
and so on.

HTH

Steve
 
B

Bearacade

Hope this helps:

Assuming Range is A1:A10

=COUNTIF(A1:A10,">=04/01/06")-COUNTIF(A1:A15,">=04/30/06")
=COUNTIF(A1:A10,">=05/01/06")-COUNTIF(A1:A15,">=05/31/06")
 
Top