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!!