Countif and fill

[lcb4kc]

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?

 

[T. Valko]

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

 

[lcb4kc]

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

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





.

 

[T. Valko]

You're welcome. Thanks for the feedback!