For example, if you click cell C3, the value of C3 will be the first number in your equation. If you type 1, the number 1 will be the first number in your equation.
You can add multiple cells or numbers at once if you’d like—just separate each number or address with another + sign. [1] X Research source For example, if you want to find the sum of cells C3, D4, and E5, your formula will look like this =C3+D4+E5. If you want to add 1 plus 1, your formula will look like this: =1+1 . You can add other operations, such as subtraction or multiplication, in the same equation. In this example, we’ll add the values of C3 and D4 and then subtract 2: =C3+D4-2
You can also select multiple columns and rows here. To select multiple non-adjacent columns and/or rows, hold down the Control key and as you select each range. You don’t have to select entire ranges with the SUM function—you can also enter individual numbers or cell addresses.
Your formula should now look something like this: =SUM(B4,B8) In this example, we’ve selected cells B4 through B8 If you selected non-adjacent ranges, each range will be separated by a comma. In this example, we selected B4 through C8 (two adjacent columns) and E4 through E5: =SUM(B4:C8,E4:E5)
For example, if you want to add the values of cells A:2 through A:10, you would click cell A11. You can also add multiple columns or rows at the same time by selecting multiple cells. For example, to display the sums of values in columns A, B, and C, you could select cells A11, B11, and C11.
If you selected multiple blank cells, you’ll see each individual column or row’s value in the selected cells.
