| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas - Countif and Fill Down | Excel Discussion (Misc queries) | |||
| Using Data Fill function to copy a Countif formula | Excel Worksheet Functions | |||
| Using Data Fill function to copy a Countif formula | Excel Worksheet Functions | |||
| countif based on fill color | Excel Worksheet Functions | |||
| Concatenate Countif formula for VBA fill-in | Excel Discussion (Misc queries) | |||
Linear Mode
