Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIFS with a date for criteria...
I want to count all the entries in column N that occurred between a range of
dates specified in the other criteria. The dates are obviously in column B. I use this currently- COUNTIFS(Data!N:N,"=Option",Data!B:B,"=1/1/2009",Data!B:B,"<=2/28/2009") However, I use this similar function in multiple cells, all counting different attributes. Rather than going into each cell and changing the search dates, I wanted a criteria to be a variable that can be entered into a different set of cells... like this. COUNTIFS(Data!N:N,"=Option",Data!B:B,"=A4",Data!B :B,"<=2/28/2009") With A4 being a cell in which to enter the date. However, it doesn't work! I get zero as a result every time. Is there a particular format i need to use to indicate a date? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIFS with a date for criteria...
Do your dates and comparisons this way:
COUNTIFS(Data!N:N,"=Option",Data!B:B,"="&A4,Data! B:B,"<="&DATE(2009,2,28)) Regards, Fred "LUSN" wrote in message ... I want to count all the entries in column N that occurred between a range of dates specified in the other criteria. The dates are obviously in column B. I use this currently- COUNTIFS(Data!N:N,"=Option",Data!B:B,"=1/1/2009",Data!B:B,"<=2/28/2009") However, I use this similar function in multiple cells, all counting different attributes. Rather than going into each cell and changing the search dates, I wanted a criteria to be a variable that can be entered into a different set of cells... like this. COUNTIFS(Data!N:N,"=Option",Data!B:B,"=A4",Data!B :B,"<=2/28/2009") With A4 being a cell in which to enter the date. However, it doesn't work! I get zero as a result every time. Is there a particular format i need to use to indicate a date? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countifs criteria | Excel Discussion (Misc queries) | |||
countifs criteria includes date range | Excel Worksheet Functions | |||
COUNTIFS AND CRITERIA | Excel Worksheet Functions | |||
countifs month criteria | Excel Discussion (Misc queries) | |||
COUNTIFs with multiple criteria | Excel Discussion (Misc queries) |