| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help w/ alternate to Countif
Formula below is pretty basic, however the problem I'm running into is
that the WB that the formula is pulling from is closed more often than not. Is there anyone that can provide me a bit of help w/ a formula that accomplishes the same thing w/ the target WB being closed? =COUNTIF('C:\Test\Test\Reports\[Test.xls]November 2007'!$N$2:$N $1000,"=8:00 PM") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help w/ alternate to Countif
Use SUMPRODUCT:
=SUMPRODUCT(--('C:\Test\Test\Reports\[Test.xls]November 2007'!$N$2:$N$1000=TIME(20,0,0))) -- Biff Microsoft Excel MVP wrote in message ... Formula below is pretty basic, however the problem I'm running into is that the WB that the formula is pulling from is closed more often than not. Is there anyone that can provide me a bit of help w/ a formula that accomplishes the same thing w/ the target WB being closed? =COUNTIF('C:\Test\Test\Reports\[Test.xls]November 2007'!$N$2:$N $1000,"=8:00 PM") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help w/ alternate to Countif
On Dec 3, 12:28 pm, "T. Valko" wrote:
Use SUMPRODUCT: =SUMPRODUCT(--('C:\Test\Test\Reports\[Test.xls]November 2007'!$N$2:$N$1000=TIME(20,0,0))) -- Biff Microsoft Excel MVP wrote in message ... Formula below is pretty basic, however the problem I'm running into is that the WB that the formula is pulling from is closed more often than not. Is there anyone that can provide me a bit of help w/ a formula that accomplishes the same thing w/ the target WB being closed? =COUNTIF('C:\Test\Test\Reports\[Test.xls]November 2007'!$N$2:$N $1000,"=8:00 PM")- Hide quoted text - - Show quoted text - Wonderful, thank you very much. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help w/ alternate to Countif
wrote in message
... On Dec 3, 12:28 pm, "T. Valko" wrote: Use SUMPRODUCT: =SUMPRODUCT(--('C:\Test\Test\Reports\[Test.xls]November 2007'!$N$2:$N$1000=TIME(20,0,0))) -- Biff Microsoft Excel MVP wrote in message ... Formula below is pretty basic, however the problem I'm running into is that the WB that the formula is pulling from is closed more often than not. Is there anyone that can provide me a bit of help w/ a formula that accomplishes the same thing w/ the target WB being closed? =COUNTIF('C:\Test\Test\Reports\[Test.xls]November 2007'!$N$2:$N $1000,"=8:00 PM")- Hide quoted text - - Show quoted text - Wonderful, thank you very much. You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum alternate rows | Excel Worksheet Functions | |||
| Alternate footers | Excel Worksheet Functions | |||
| alternate blank row | Excel Worksheet Functions | |||
| analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
| How to sum-up alternate rows ? | Excel Worksheet Functions | |||
Hybrid Mode
