Is this possible? I have used a sum formula to sum up from another workbook, but when I do a countifs statement I get the #VALUE! error!

Thanks in advance!