# data[].attributes.body
Being used for mainly math and calculations with many shortcuts for complex equations

# data[].attributes.attachment_link.readable_text
Instead of reaching for your calculator, use Microsoft Excel to do the math!

On a worksheet, you can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. You can also use the AutoSum feature to quickly total a series of values without having to enter any of them manually in a formula. After you create a formula, you can copy it into adjacent cells - no need to create the same formula over and over again.

When you become familiar with these simple formulas, you may want to learn more about how to create complex formulas and try some of the many functions that are available in Excel. For more information, see Overview of formulas and List of worksheet functions (by category).

Note: The images below display aspects of Excel 2016. Your view might be different if you're using another version of Excel.

Learn more about simple formulas

All formula entries begin with an equal sign (=). For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use - the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide. Then, press ENTER, and Excel instantly calculates and displays the result of the formula.

For example, when you type =12.99+16.99 in cell C5 and press ENTER, Excel calculates the result and displays 29.98 in that cell.

The formula that you enter in a cell remains visible in the formula bar, and you can see it whenever that cell is selected.

Important: Although there is a SUM function, there is no SUBTRACT function. Instead, use the minus (-) operator in a formula; for example, =8-3+2-4+12. Or, you can use a minus sign to convert a number to its negative value in the SUM function; for example, the formula =SUM(12,5,-3,8,-4) uses the SUM function to add 12, 5, subtract 3, add 8, and subtract 4, in that order.

Use AutoSum

The easiest way to add a SUM formula to your worksheet is to use AutoSum. Select an empty cell directly above or below the range that you want to sum, and on the Home or Formula tabs of the ribbon, click AutoSum > Sum. AutoSum will automatically sense the range to be summed and build the formula for you. This also works horizontally if you select a cell to the left or right of the range that you need to sum.

Note: AutoSum does not work on non-contiguous ranges.

AutoSum vertically

In the figure above, the AutoSum feature is seen to automatically detect cells B2:B5 as the range to sum. All you need to do is press ENTER to confirm it. If you need to add/exclude more cells, you can hold the Shift Key + the arrow key of your choice until your selection matches what you want. Then press Enter to complete the task.

Intellisense function guide: the SUM(number1,[number2], ...) floating tag beneath the function is its Intellisense guide. If you click the SUM or function name, it will change o a blue hyperlink to the Help topic for that function. If you click the individual function elements, their representative pieces in the formula will be highlighted. In this case, only B2:B5 would be highlighted, since there is only one number reference in this formula. The Intellisense tag will appear for any function.

AutoSum horizontally

Learn more in the article on the SUM function.

Avoid rewriting the same formula

After you create a formula, you can copy it to other cells - no need to rewrite the same formula. You can either copy the formula, or use the fill handle to copy the formula to adjacent cells.

For example, when you copy the formula in cell B6 to C6, the formula in that cell automatically changes to update to cell references in column C.

When you copy the formula, ensure that the cell references are correct. Cell references may change if they have relative references. For more information, see Copy and paste a formula to another cell or worksheet.

Do you have a specific Excel question?

Post a question in the Excel community forum

Help us improve Excel

Do you have suggestions about how we can improve the next version of Excel? If so, check out the topics at Excel User Voice.

# data[].attributes.attachment_link.description
Instead of reaching for your calculator, use Microsoft Excel to do the math! On a worksheet, you can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. You can also use the AutoSum feature to quickly total a series of values without having to enter any of them manually in a formula.

# data[].attributes.body
Bold grid lines, column making, pie charts, picture inserts, formulas, and currency.

# data[].attributes.body
Autosum, Bold, Autofill

# data[].attributes.body
=sum

# data[].attributes.body
-Jacob El-Abbadi

# data[].attributes.body
computer progamer

# data[].attributes.body
Labels, Columns, Rows

# data[].attributes.body
auto sum,labels,cells,

# data[].attributes.body
Jacob El-Abbadi

# data[].attributes.body
HH3

# data[].attributes.body
=Sum, *, /, =IFstatement,

# data[].attributes.body
auto sum

# data[].attributes.body
Jacob El-Abbadi

# data[].attributes.body
computer programming

# data[].attributes.body
=sum

# data[].attributes.body
=sum

# data[].attributes.body
Computer Programmer, Marketing/Sales man, Communications Manager, Inventory Stocker at a store, and a Financial Analyst

# data[].attributes.body
=sum

# data[].attributes.body
computer programmer

# data[].attributes.body
_________
| 2B+3B |
^^^^^^^^^^

# data[].attributes.body
spell it right

# data[].attributes.body
=PRODUCT

# data[].attributes.body
1a+2a+3a

# data[].attributes.body
-Jacob El-Abbadi

# data[].attributes.body
calculate large posentis

# data[].attributes.body
video game developer
graphic designing
software developer

# data[].attributes.body
IT Technical Support

# data[].attributes.body
=sum(b4:b8)

# data[].attributes.body
4c+5c

# data[].attributes.body
ctrl+c

# data[].attributes.body
Business Teacher

# data[].attributes.body
=b4*b5 =SUM(c8:f10)

# data[].attributes.body
Market sales man

# data[].attributes.body
HH3

# data[].attributes.body
Tax calculations

# data[].attributes.body
Ctrl + C or Ctrl = V

# data[].attributes.body
Accountants

# data[].attributes.body
AUTOSUM

# data[].attributes.body
IT specialist

# data[].attributes.body
=SUM(B3:G3)

# data[].attributes.body
=sum(b1+b2)

# data[].attributes.body
sales man