COUNTIF Question
 

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.

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

--

HTH

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


"Jim" wrote in message
...
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.

Try

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

--

_______________________
Naz,
London


"Jim" wrote:

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.

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.

"Naz" wrote:

Try

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

--

_______________________
Naz,
London


"Jim" wrote:

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.