To add multiple cells in Excel, you primarily use the SUM function. Here's how:
Using the SUM Function
The SUM function is the most straightforward way to add numbers in different cells.
Basic Summation
-
To add a range of consecutive cells, use this formula:
=SUM(A1:A10)This will add all the values in cells A1 through A10. Replace
A1:A10with your desired cell range.
Adding Non-Consecutive Cells
-
To add individual cells that are not next to each other, use this formula:
=SUM(A1, A3, A5)This will add the values in cells A1, A3, and A5. You can include as many individual cells as needed, separated by commas.
Combining Ranges and Individual Cells
-
You can also combine ranges and individual cells in a single
SUMformula:=SUM(A1:A5, B2, C1:C3)This will add the values in the range A1 to A5, the value in cell B2, and the values in the range C1 to C3.
Examples
Here are some examples using hypothetical cell values:
| Cell | Value |
|---|---|
| A1 | 10 |
| A2 | 20 |
| A3 | 30 |
| A4 | 40 |
| A5 | 50 |
| B1 | 5 |
| C1 | 15 |
=SUM(A1:A5)would return 150 (10 + 20 + 30 + 40 + 50)=SUM(A1, A3, A5)would return 90 (10 + 30 + 50)=SUM(A1:A3, B1)would return 65 (10 + 20 + 30 + 5)
Alternative: Using the "+" Operator
While the SUM function is generally preferred, you can also add cells using the plus sign (+):
=A1 + A2 + A3
This method is less efficient for large ranges but can be useful for adding a few specific cells. Using SUM is almost always better, especially for readability and maintainability.
Summary
The easiest way to add multiple cells in Excel is using the SUM function. You can add consecutive ranges like A1:A10, individual cells like A1, B2, C3, or a combination of both. Remember to start your formula with an equals sign (=).
