What Excel function is used to add numbers in a range of cells?

Answer 1

The syntax is... sum(start:end) - where 'start' is the first cell in the range and 'end' is the last.

Answer 2

To get a total, which can also be called an aggregate, you should use the SUM function. You list the cell references, or the cell range with the values you want to add inside the function. Arrange the values you want to add in a column if possible. Then, suppose your values were in column B, from B2 to B20, you would do this in a blank cell:

=SUM(B2:B20)

That will total all the values in those cells. The colon indicates the range being between those two cells. If the cells are in a row, say row 3 from column B across to column K, then the formula would be like this:

=SUM(B3:K3)

If the cells are in separate cells spread around, you can create a comma separated list in the SUM function, and even include a mix of ranges and individual cells, like this:

=SUM(B4,B8,B11,D3:D10,F15)

Answer 3

In a spreadsheet you use the Sum function.

Answer 4

The syntax is... sum(start:end) - where 'start' is the first cell in the range and 'end' is the last.

Answer 5

You can use the =SUM function or you can go to the cell below the numbers you want to sum and click on the Auto Sum button.

Answer 6

The SUM function, like this: =SUM(A1:A23)

Answer 7

The SUM function.