Sum of non-adjacent cells or multiple columns

[Ehsanuls55]

Using a single formula, add numbers from nonadjacent cells or multiple columns. Watch out for this:

Select the empty cell where the sum should appear
Type '=SUM(' followed by the comma-separated cell number or the comma-separated range of cells. For example, to sum nonadjacent cells, add the totals for May and June by adding E13 and J13 using the formula =SUM(E13 + J13) and press Enter
Sum of non-adjacent cells or multiple columns

Screenshot via Google Sheets_

Alternatively, use =SUM(E3:E12, J3:J12) and press the Enter key to get the total cfo email lists sum of both columns.
Sum of non-adjacent cells or multiple columns

Screenshot via Google Sheets_

Method 3: Adding on multiple sheets
Let's say your Google Sheets contains information spread across multiple sheets and you need to add the same column to each of them. Here's how to use the Google Sheets SUM function to do this:

Select the cell in the spreadsheet where you want the sum to appear
Write the SUM formula, but instead of a single range, reference multiple sheets. Since our data is spread across the sheets "May" and "June" and the sum is for the range E3 to E12, the formula would be =SUM(May!E3:E12, June!E3:E12)
Sum of several sheets

Screenshot via Google Sheets_


Press the Enter key to get the sum of all the sheets referenced in the selected cell