How do you calculate the sum on Excel?

Answer 1

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)

Answer 2

There are lots of ways. You can use the SUM function to do it. You can use the SUBTOTAL function to do it. You can use Alt and the plus sign to do it. You can use the Autosum icon to do it. You could also just individually add the cells.

Answer 3

You can use the SUM function to do so. You need to specify what you want to sum. Usually it is part of a column. Say you wanted to sum the cells from cell B1 to B200, you would use the SUM as follows:

=SUM(B1:B200)

To do an entire column you use just the letters of the column, so for column B, that would be done like this:

=SUM(B:B)

Answer 4

You can use the plus symbol for small calculations that don't involve many values, or else use the Sum function. If you wanted to add the values in cells A1, A2, A3, A4 and A5 you could do it in the following ways:

=A1 + A2 + A3 + A4 + A5
=sum(A1, A2, A3, A4, A5)

or the best way, by referring to the whole range by its first and last cells as follows:

=sum(A1:A5)

You can also use the AutoSum to automatically do the calculation. You can place the cursor under or beside the cells you want to sum, or select the cells and click the AutoSum and it will put the total into a blank cell.

Answer 5

You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:

=SUM(Sheet1!A2:A20)