LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default 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")

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum alternate rows anand Excel Worksheet Functions 4 June 19th 07 07:59 AM
Alternate footers Bee Excel Worksheet Functions 3 March 14th 07 09:25 PM
alternate blank row bayanbaru Excel Worksheet Functions 3 June 3rd 05 11:47 PM
analysing data from alternate columns using the countif function Juniper Excel Discussion (Misc queries) 3 April 28th 05 04:12 PM
How to sum-up alternate rows ? lolex Excel Worksheet Functions 3 November 5th 04 11:57 AM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"