=SUMPRODUCT(--('C:\myDocs\[myBook.xls]Sheet1'!$A$1:$A$20="a"))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"calli" wrote in
message ...
Hi,
I'm trying to count the number of time a specific value appers with in
a range of cells, but I want to place the results in a seperate
workbook. How do I do this.
Thanks in advace for any help
Calli
--
calli
------------------------------------------------------------------------
calli's Profile:
http://www.excelforum.com/member.php...o&userid=37561
View this thread: http://www.excelforum.com/showthread...hreadid=572395