Countif and fill

  • Thread starter Thread starter lcb4kc
  • Start date Start date
L

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?
 
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
 
Thanks so much...works great!!!!

T. Valko said:
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





.
Click to expand...
 
Back
Top