1

I'm importing an Excel spreadsheet into Google Drive. Its a huge spreadsheet, and overall Google spreadsheets has converted everything, except the following:

There are a few cells with formulas like this:

=SUM('Mon-D:Sun-D'!$DN$209)

Where among the many sheets, some are named Mon-D and Sun-D. But it isn't working - instead I have the error #REF!

Error: Unresolved sheet name 'Mon-D:Sun-D'.

So the next thing I did was wrap the names in quotes as I thought maybe it was getting confused:

=SUM("'Mon-D':'Sun-D'"!$DN$209)

or

=SUM('Mon-D':'Sun-D'!$DN$209)

But both give me Error: Formula parse error. I'm not very familiar with Excel, or Google Drive - what am I doing wrong? I'm guessing I need to separate the sheet names more clearly somehow.

1

Maybe:

=sum('Mon-D'!$DN$209,'Tue-D'!$DN$209,'Wed-D'!$DN$209,'Thu-D'!$DN$209,'Fri-D'!$DN$209,'Sat-D'!$DN$209,'Sun-D'!$DN$209)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.