countif doesnt work on closed work books
http://support.microsoft.com/kb/260415