I should have said
=SUMPRODUCT(('C:\yourfolder\[yourfilename.xls]yourworksheet'!$B$5:$B$9="SF")*1)

--
Don Guillett
SalesAid Software

"Treesy" wrote in message
...
I am trying to use the CountIF function in Workbook A that counts info in a
range of cells located in Workbook B. I'd like Worksheet A to update when
changes to Worksheet B is made. But the function only works if Workbook B
is
open, otherwise I get the dreaded #VALUE! error. What am I doing wrong?

Thanks!!