Countif showing #value error

Guys,
im using 2 workbooks and need 2 keep an update of 1 of them the other workbook will be used by another department if they havnt got there work book open my book comes up with #value error is there a way around this i have left 2 test workbooks for examples

Puzzled thanks