COUNTIF Question

J

Jim

This is probably basic but for some reason I can't seem to get past it. I'm
trying to create a status file to keep track of a large task I'm doing at
work.

I'm reviewing a long series of documents and making corrections to each
(about 700 of them total). I set up a sheet "Details" where each row
corresponds to one of the documents I review. I put the date I finish each
document in column C (mm/dd/yyyy format). I would like to have Excel count
up how many documents I do in each week (week ending Friday like 4/1/2005,
4/8/2005, etc.) and display the weekly totals. The totals are on a separate
sheet from the raw data ... I have a sheet named "Summary" and another sheet
called "Details" that has all the 700 data rows.

I tried entering something like =COUNTIF(Details!C3:C750,"<=b11") in cell
C11 of sheet Summary, where B11 just says 4/22/2005, but Excel shows the
count as 0 even though I know I have dates in May 2005 in column C of sheet
Details.

If someone can point out what I'm doing wrong I'd appreciate it, I hope I
gave enough information.
 
B

Bob Phillips

=COUNTIF(Details!C3:C750,"<="&B11)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

Jim

OK, yes that helped, thanks guys. The book I have doesn't really seem to go
into the syntax to build formulas like that, like when I would need an
ampersand operator or whatever, it doesn't even mention it.
 
Top