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