countif

  • Thread starter Thread starter majestyk
  • Start date Start date
M

majestyk

Can anyone help please!!!
I need to count the occurences of date vales (non specific) between the 1st
and 31st of each month. Dates are posted in a column and the name range
called Presentations.
So far I have
tried:countif(presentations,and(">="&"1/3/2008","<="&"31/3/2008")). The
result has to state how many presentations occured between the dates
specified. The only other way was to break it down to weekly occurences
(multiple countif) and them sum them.
Majestyk
 
This would do the same thing:

=SUMPRODUCT(--(MONTH(presentations)=1))

Change the month to 2 for February.
 
If its for dates falling within a certain month/year:
=SUMPRODUCT(--(TEXT(presentations,"mmmyyyy")="Mar2008"))

If its for a certain date range which may straddle across months,
then something unambiguous like this:
=SUMPRODUCT((presentations>=--"1 Feb 2008")*(presentations<=--"15 Mar 2008"))

Real dates are presumed within the defined range: presentations

Pl mark responses which help by clicking the YES buttons below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
 
Back
Top