using countif to add dates
 

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

using countif to add dates
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=547897

using countif to add dates
 

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")


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=547897