#REF Error when summing

[jrkujak]

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!

[romperstomper]

You would need INDIRECT, but INDIRECT does not work with 3D ranges (unless you pass the sheet names as an array, which you can't do if they are in a cell).

[arthurbr]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.