Count if 0 and between dates
Use cells to hold your date boundaries:
A1 = start date = 1/1/2008
B1 = end date = 1/31/2008
A3:A12 = dates
If you're using Excel 2007:
=COUNTIFS(A3:A12,"="&A1,A3:A12,"<="&B1)
For any version of Excel:
=COUNTIF(A3:A12,"="&A1)-COUNTIF(A3:A12,""&B1)
--
Biff
Microsoft Excel MVP
"Stilmovin" wrote in message
...
I have been looking all over this site trying to find the answer and came
up
with nothing.
I have a spread sheet that contains three columns: Date Cost Award
I am trying to count the number of awarded between a date(January)
I have tried the sumproduct and sumif equations to come up with the
following
=COUNTIFS(P6:R93,"0",E6:E93,"2008Jan")
- #Value!
=COUNTIF(E5:E80,"=10/9/2008")-COUNTIF(E5:E80,"=10/10/2008")
- This resulted in only counting the dates and not the # of Awarded
HELP!!
|