I would opt for SUMPRODUCT in preference to COUNT(IF or SUM(IF CSE Array as it will be slightly more robust for the end user (ie can be committed with ENTER as normal - no CSE requirement)

eg using your sample file(s)

=SUMPRODUCT(--('C:\your file path\[Test2.xls]22-09-09'!$A$1:$J$3="Test"))