I have multiple sheets in my Google Spreadsheet. Let's suppose that they are named "1", "2", … "n". I would like to sum the contents of the B4 cells in all of these sheets. Is it possible to specify a range of sheets, or do I need to meticulously include a reference to each sheet?
Google-sheets – Google sheets range of sheets
google sheets
Related Topic
- Google-sheets – How to reference a range of data in another workbook (not importing)
- Google-sheets – Dynamically Building Array Of Sheet Names From A Range Of Cells
- Google-sheets – How to set a default value for cells in Google Sheets
- Google-sheets – How to create a dynamic named range
- Google-sheets – Google Sheets, formula, reference to variable sheets
- Google-sheets – Adding cells from multiple Google Sheets into a “master” sheet
- Google-sheets – Reference formulas from one sheet into multiple sheets
- Google-sheets – How to apply formatting on specific Google Sheets and columns
Best Answer
You have a Spreadsheet containing n sheets (named "1", "2", "3", "4", "5" and so on) which have identical formatting. You want an efficient way to sum the values of a given cell (B4) from every sheet.
An option is to use a custom function such as sum-sheets-cell.js on Github.
Since your sheets are named in numerical sequence, I have modified the function to automatically insert the sheet names and cell reference.