Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif
This would do the same thing:
=SUMPRODUCT(--(MONTH(presentations)=1)) Change the month to 2 for February. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "majestyk" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif
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 --- "majestyk" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |