I'm having trouble with an external reference in one of my Excel Functions.
The general form of my function is:

=COUNTIF( external reference to a range, a value)

When I open my worksheet and tell it to update the data, the cells with this
formula indicate that there is an error with my function. But then, when I
open the workbook containing the external reference, my formulas miraculously
correct themselves.

Just some additional info. -- I have other formulas that work which
reference the same external data.

If anybody could give me a clue to what might be going on, I'd surely
appriciate it. I've pasted the actual formulas that I've used in case
anybody is willing to take a close look at what I've done :).

Thanks in advance,

-Greg

Formula that doesn't work:
=COUNTIF('E:\ResearchData_Math90\AlteredDataAndSpr eadsheets\QueryResults\[math090_A453_CompleteInfoQueryResults.xls]math090_A453_CompleteInfoQueryR'!$D$2:$D$416, B3)

Formula That Works:
{=SUM( IF(
(NOT('E:\ResearchData_Math90\AlteredDataAndSpreads heets\QueryResults\[math090_A453_CompleteInfoQueryResults.xls]math090_A453_CompleteInfoQueryR'!$B$2:$B$416=5925) )
*
('E:\ResearchData_Math90\AlteredDataAndSpreadsheet s\QueryResults\[math090_A453_CompleteInfoQueryResults.xls]math090_A453_CompleteInfoQueryR'!$D$2:$D$416=B3),1 ,0))}