قالب وردپرس درنا توس
Home / Tips and Tricks / Add cells in Excel

Add cells in Excel

  Microsoft Excel Laptop Finance Business

Add is one of the most important functions in Excel. You will find that almost every project requires a degree of basic math. However, there are quite a few different ways to achieve your goal. Here are a few tips for adding cells in Excel.

To add more than cells, you can also refer to the extensive Excel tutorial for explanation here.

Adding cells in Excel: [19659006] The easiest way to add cells in Excel is to write a basic formula.

1. Start with an equal sign (=) followed by your cells separated by a plus sign (+). In our example this reads as = A2 + A3 + A4 .

  adding cells in Excel 1

2. Press Enter to get your result.

  adding cells in Excel 2

This method is easiest if you just add a few cells and don't mind checking them out typing. However, you will probably notice that it is faster to use the SUM function to add long series of cells.

1. Start over with the equal sign, because that's how all formulas start. Then type SUM ( to start your function.

  add cells in Excel 3

2. Now you can type add the cells you want to add and divide them by commas This would be: = SUM (A2, A3, A4) .

 ] add cells in Excel 4

2a If you add a series of solid cells, you can also separate them in your equation with a colon, this is easier if you have a long list because you can enter only the first and last cells, in our example it would look like this: = SUM (A2: A4) .

2b A third way to fill in your formula is to click and drag After you = SUM (), you can select the first cell you want to add and drag to the last cell. Excel does the rest and separates it with a colon.

  add cells in Excel 6

2c. You can even sum all the cells in a column by specifying the cells in your formula as A: A. It will be displayed as = SUM (A: A) in your formula bar.

3. Press Enter after choosing your cells to see the result.

  adding cells in Excel 2

These are the most basic ways to add cells in Excel, but there are plenty of additional applications for adding in Excel.

What else can I do?

If you want to extend your new Excel skills to more than just addition, you may be interested in some more structured training. We are now highlighting a deal that offers just that.

It's called the Complete Microsoft Excel and VBA bundle and it includes nine online modules to help you increase your skills. You can go through many aspects of VBA to create time-saving macros and other useful features. If you want more general information, the learning kit also includes it for the three latest versions of Excel.

  The complete Microsoft Excel and VBA bundle

The complete Microsoft Excel and VBA bundle has a total resale value of $ 300, but you can already get started for just $ 29.99 in tech deals. More than 3,000 people have already started studying, so get involved now that the content is on sale.

Source link