I am using the following formula:
=COUNTIF('C:\Users\Chris Edwards\Documents\Work\New Stuff\July\Team 1\[Anna.xls]Input Sheet'!AP$22:AP$671,B6)
If I open this sheet when "Anna" is not open, I get #VALUE! errors with the message "A value used in the formula is of the wrong data type."
When I open "Anna", all of the formula's then calculate and give me the correct results.
What could be causing this and how do I fix it?
Thanks!