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