Question

How to add using the formulas in computet

Answer 1

Answer:

To perform the SUM formula, enter the values you'd like to add together using the format, =SUM(value 1, value 2, etc). The values you enter into the SUM formula can either be actual numbers or equal to the number in a specific cell of your spreadsheet.

Answer 2

SUM

All Excel formulas begin with the equals sign, =, followed by a specific text tag denoting the formula you'd like Excel to perform.

The SUM formula in Excel is one of the most basic formulas you can enter into a spreadsheet, allowing you to find the sum (or total) of two or more values. To perform the SUM formula, enter the values you'd like to add together using the format, =SUM(value 1, value 2, etc).

The values you enter into the SUM formula can either be actual numbers or equal to the number in a specific cell of your spreadsheet.

To find the SUM of 30 and 80, for example, type the following formula into a cell of your spreadsheet: =SUM(30, 80). Press "Enter," and the cell will produce the total of both numbers: 110.

To find the SUM of the values in cells B2 and B11, for example, type the following formula into a cell of your spreadsheet: =SUM(B2, B11). Press "Enter," and the cell will produce the total of the numbers currently filled in cells B2 and B11. If there are no numbers in either cell, the formula will return 0.

Keep in mind you can also find the total value of a list of numbers in Excel. To find the SUM of the values in cells B2 through B11, type the following formula into a cell of your spreadsheet: =SUM(B2:B11). Note the colon between both cells, rather than a comma. See how this might look in an Excel spreadsheet for a content marketer, above picture