3rd time is the charm! Linking CountIF formula

From: BenJAMMIN (BenjAMMIN_at_discussions.microsoft.com)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 14:16:02 -0700

After much bally ho this morning, this formual DID work this morning.
=COUNTIF('[Floyd.xls]July # of Obs'!C7:L7,"Care")+COUNTIF('[Dunlap.xls]July
# of Obs'!C7:L7,"Care")

But then I saved the work***, opened it up an hour later and the file names now display the full network paths:
=COUNTIF('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Floyd.xls]July # of Obs'!C7:L7,"Care")+COUNTIF('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Dunlap.xls]July # of Obs'!C7:L7,"Care")+COUNTIF('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Cooper.xls]July # of Obs'!C7:L7,"Care")

When I attempt to create the formual back to the original one listed above, I receive the #VALUE! error! ARRGGHH!

Someone mentioned using NON Array formula, would that help out this issue?