109k views
5 votes
How to do the following instruction ; in a cell, enter a formula using the SUM function to total the values in a cell range (B4:B15)?

User Simpletron
by
8.3k points

1 Answer

6 votes

Final answer:

The SUM function in spreadsheet programs totals the values in a specified cell range, and to use it, you enter =SUM(B4:B15) in the desired cell.

Step-by-step explanation:

To total the values in a cell range (B4:B15) using the SUM function in a spreadsheet program such as l or Sheets, you would enter the formula =SUM(B4:B15) into the cell where you want the total to appear. This formula adds up all the numerical values from cells B4 through B15 and displays the result in the cell where you entered the formula.

To total the values in a cell range (B4:B15), you can use the SUM function in Excel. Here's how you can do it: Select the cell where you want the total to appear. Type the formula =SUM(B4:B15) into the cell. Press Enter, and the cell will display the sum of the values in the range. For example, if the values in the range B4:B15 are 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, and 12, the formula =SUM(B4:B15) will give you a total of 78.

User Puggie
by
8.0k points