#REF Error when summing

Hi everyone, I keep getting this error #REF When trying to Sum Cell A1 which contains
2001:2003!A1. I have tried Sum(A1),Sum(INDIRECT(A1)), Sum(Concatenate(A1)). None of which seem to work. Any ideas would be greatly appreciated.

Thanks in advance!