How to Sum Across Multiple Sheets in Google Sheets

To sum across multiple sheets in Google Sheets, you can use the INDIRECT function in conjunction with the SUM function. The INDIRECT function allows you to reference a cell from another sheet, while the SUM function adds up the values specified within its argument.

Here's an example of how to sum across multiple sheets in Google Sheets:

Example

Suppose you have three sheets named "January", "February", and "March", and you want to sum the values in cell B2 from all these sheets. You can follow these steps:

1. Create a new sheet or use an existing sheet where you want to display the total sum.
2. In the cell where you want to display the sum, enter the following formula:

=SUM(INDIRECT("January!B2"), INDIRECT("February!B2"), INDIRECT("March!B2"))

3. Press Enter.

This formula uses the INDIRECT function to reference cell B2 from each of the sheets "January", "February", and "March". Then, it uses the SUM function to add up the values from those cells.

If you want to add more sheets to the sum, you can simply extend the formula by adding more INDIRECT references. For example, if you have an additional sheet named "April", you can modify the formula like this:

=SUM(INDIRECT("January!B2"), INDIRECT("February!B2"), INDIRECT("March!B2"), INDIRECT("April!B2"))

This method allows you to sum across multiple sheets in Google Sheets easily.