Google-sheets – Conversion from Excel to Google Spreadsheet – sum across sheets

formulasgoogle sheets

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.

Best Answer

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)
Related Topic