How Do I Add a Sum in Google Sheets?

You can add a sum in Google Sheets by using the SUM function. There are a few ways to do this:

Using the SUM Function Directly

1. Select the cell where you want the sum to appear.
2. Type =SUM( (that's an equals sign, followed by SUM, followed by an open parenthesis).
3. Select the range of cells you want to add. You can do this by:
   • Clicking and dragging your mouse over the cells.
   • Typing the cell range manually (e.g., A1:A10).
   • Clicking on individual cells while holding down the Ctrl (or Cmd on Mac) key. This allows you to sum non-contiguous cells.
4. Type ) (a closing parenthesis).
5. Press Enter.

Example: To sum the values in cells A1 through A10, you would enter =SUM(A1:A10) into the desired cell and press Enter.

Using the "Insert Function" Option

1. Select the cell where you want the sum to appear.
2. Click on the "Insert" menu in the top toolbar.
3. Select "Function"
4. Choose "SUM" from the list of available functions, or search for "SUM".
5. A formula bar will appear. Select the cells you wish to add, using the same methods as described above.
6. Press Enter.

Example using individual cells

To sum the values in cells A1, A3, and A5, you would enter =SUM(A1,A3,A5) into the desired cell and press Enter.