Countif and fill
 

Hi,

I have a formula =COUNTIF('Details 2007'!A:A,"October 11, 2007") and i would
like to fill the cell below ii with =COUNTIF('Details 2007'!A:A,"October 18,
2007") and make a series that I could fill (the values would be in 1 week
increments). Is this possible?

Countif and fill
 

One way...

Let's assume you want the first result in cell C2.

Enter this formula in C2 and copy down as needed:

=COUNTIF('Details 2007'!A:A,DATE(2007,10,11+(ROWS(C$2:C2)-1)*7))

C2 will count for October 11, 2007
C3 will count for October 18, 2007
C4 will count for October 25, 2007
C5 will count for November 1, 2007
etc
etc

--
Biff
Microsoft Excel MVP


"lcb4kc" wrote in message
...
Hi,

I have a formula =COUNTIF('Details 2007'!A:A,"October 11, 2007") and i
would
like to fill the cell below ii with =COUNTIF('Details 2007'!A:A,"October
18,
2007") and make a series that I could fill (the values would be in 1 week
increments). Is this possible?

Countif and fill
 

Thanks so much...works great!!!!

"T. Valko" wrote:

One way...

Let's assume you want the first result in cell C2.

Enter this formula in C2 and copy down as needed:

=COUNTIF('Details 2007'!A:A,DATE(2007,10,11+(ROWS(C$2:C2)-1)*7))

C2 will count for October 11, 2007
C3 will count for October 18, 2007
C4 will count for October 25, 2007
C5 will count for November 1, 2007
etc
etc

--
Biff
Microsoft Excel MVP


"lcb4kc" wrote in message
...
Hi,

I have a formula =COUNTIF('Details 2007'!A:A,"October 11, 2007") and i
would
like to fill the cell below ii with =COUNTIF('Details 2007'!A:A,"October
18,
2007") and make a series that I could fill (the values would be in 1 week
increments). Is this possible?


.

Countif and fill
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"lcb4kc" wrote in message
...
Thanks so much...works great!!!!

"T. Valko" wrote:

One way...

Let's assume you want the first result in cell C2.

Enter this formula in C2 and copy down as needed:

=COUNTIF('Details 2007'!A:A,DATE(2007,10,11+(ROWS(C$2:C2)-1)*7))

C2 will count for October 11, 2007
C3 will count for October 18, 2007
C4 will count for October 25, 2007
C5 will count for November 1, 2007
etc
etc

--
Biff
Microsoft Excel MVP


"lcb4kc" wrote in message
...
Hi,

I have a formula =COUNTIF('Details 2007'!A:A,"October 11, 2007") and i
would
like to fill the cell below ii with =COUNTIF('Details
2007'!A:A,"October
18,
2007") and make a series that I could fill (the values would be in 1
week
increments). Is this possible?


.