Thread: countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
majestyk majestyk is offline
external usenet poster
 
Posts: 8
Default 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