How to add multiple cells from different sheets in google sheets

Is it possible to range over sheets in one spreadsheet ?

Ive got sheets: S, A, B, C, D. In S I would like to do (for some cell C4):

 =SUM(A:D!C4) 

To sum C4 in A, B, C, and D. It is doable in google spreadsheet at all ?

Mogsdad

43.5k20 gold badges147 silver badges263 bronze badges

asked Jan 12, 2014 at 22:24

You just need to mention the sheet names as well. Though, you'll have to mention each sheet name seperately. Something like this would work

=SUM(A!C4, B!C4, C!C4, D!C4)

answered Jan 13, 2014 at 2:27

ChrisChris

8687 silver badges6 bronze badges

2

I think the answer to this is that it isn't possible on google sheets as yet.

Would love if Sheets actually had similar functionalities.

answered Feb 21, 2019 at 7:30

3

When working with spreadsheets in Microsoft Excel, you might find yourself needing to add up business data from cells across multiple spreadsheets. It is possible to make the Sum Excel formula reference another sheet, or multiple sheets, and add up a range of cells across those sheets.

How to Use the Sum Function to Add Cells in the Same Sheet

You can use the Sum function to add up the data in two or more cells, or all of the data within a range of cells. To do so, you can either type out the Sum function manually, or use the Auto*Sum* button located in the Editing Section on the Excel menu bar.

To use the Sum function to add up a column of cells on the worksheet you are working on, simply click the first open cell at the bottom of the column you want to add, and click the AutoSum button to insert the Sum function. This will automatically tally the sum of the cells in the column you have chosen after you hit Enter.

If you want to type out the Sum function, either to specify which individual cells to add regardless of columns, write the Sum function as follows: =SUM(cell1, cell2). As an example, this would look something like =SUM(A14,B17) when formatted with two cells. You can add up a range of cells with the Sum formula by using a colon instead of a comma, like so: =SUM(A1:A14).

How to Find an Excel Sum From Another Sheet.

To find an Excel Sum from another sheet, you will first need to pick a cell where your total Sum formula will go. This can go on any of the sheets in your Excel document. Then, you will need to format the sum formula to reference the other sheet with the cell or range of cells you want to add.

To add cells located in a different worksheet to your formula, first start the Sum formula by typing "=SUM(" and then click the cell located in that other worksheet. Type a comma, then select any other cell.

How to Make the Sum Excel Formula Reference Another Sheet

To reference a separate sheet outside of the sheet you are in, you can do so in a few ways. First, you can select the cells you want to add from another worksheet by clicking them while holding the Ctrl key. Second, you can type the name of the sheet you want to reference manually as part of your Sum formula. You can find the name of any sheet in your document by checking the bottom tabs of your Excel workbook.

Once you have the name of the sheet you want to reference, here's how you change your Excel Sum formula so multiple sheets can be referenced at one time. Add the name of the sheet, followed by an exclamation point, and then the name of the cell you want to add: =SUM(Sheet1!A14,Sheet2!B17). That will make the Excel formula reference another sheet, but you can also simplify the formula to =SUM(A14,Sheet2!B17), which will add a cell from another sheet to a cell on your current sheet.

Let’s say you have a workbook with your company's revenue data from each month on a separate sheet. If you wanted to add the revenue from the January and February sheets together, you could either click and select the cells from January and February, or type your formula manually to look something like this: =SUM(Jan!C12,Feb!C12). After you hit enter, your cell should have the sum of the total revenue from the January and February sheets in it.

Excel Sum Formula: Multiple Sheets, Multiple Cells

Keeping with the above example, let’s say once the year is over, you want to add up each cell containing every month’s total revenue from your entire range of sheets. You can click the + sign to create a new sheet, and click the name to rename "Sheet1" as "Revenue" and then pick a cell to put your formula in.

To add an Excel Sum formula across multiple sheets, determine the range of sheets in question by separating them with a colon in your Sum formula, written like so: =SUM(Sheet1:Sheet12!Cell#). This references all of the sheets in a range, and the corresponding cell across every sheet. In this instance, you want the total revenues you are adding to be in the same corresponding cell across each sheet. For our example, where we want to find the sum of the total revenue of all twelve months, the formula would look like =SUM(Jan:Dec!C12).

Alternatively, you can reference a range of cells to add up across all sheets instead, like so: =SUM(Sheet1:Sheet12!A12:C12). This adds all the cells from A12 through C12 across Sheet1 through Sheet12. For our example, if you wanted to find the sum of a range of cells across each month's sheet, instead of adding one cell of each sheet, that formula would look like this: =SUM(Jan:Dec!A12:C12).

How do I sum cells from different sheets in Google Sheets?

How do I add cells from different worksheets?

How do I sum cells across multiple tabs?

How do I auto populate information from one tab to another in Google Sheets?