countif

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
 
J

JBeaucaire

This would do the same thing:

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

Change the month to 2 for February.
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs with multiple dates 2
counting multiple dates in a range 1
Countif 2
Countif 2
nightmare formula 4
Countif with dates for vs 2003 8
Multiple count if 2
countif 2

Top