Re: 3rd time is the charm! Linking CountIF formula

From: Dave Peterson (ec35720_at_msn.com)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 18:57:17 -0500

Maybe you could use a different function (multiple times!):

=SUMPRODUCT(--('\\myfolder1\myfolder2\[floyd.xls]SheetName'!C7:L7="Care"))
+sumproduct(--(your next one))
+sumproduct(--(your next one))

(You'll have to fix all the references--I got lazy!)

BenJAMMIN wrote:
>
> 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? 

-- 
Dave Peterson
ec35720@msn.com