How to using Sum and AutoSum in Excel 2010

Learn how to work with sum and autosum functions in Excel. Knowing how to work with them can help you greatly in your calculations.

Don’t forget to check out our site for more free how-to videos!
– our feed
– join us on facebook
– our group in Google+

Whenever you have to work with tons of numbers and make various calculations, use the sum function in Excel to make your task easy. You can also apply autosum in excel to make calculations for you. Furthermore in this tutorial, we will show you how to check these functions at a glance for any errors that might exist. Follow this step by step guide and master the sum functions that Excel has to offer.

In this tutorial, we will show you how to add numbers using Sum and AutoSum in Excel.

Step # 1 — Use the Sum function
Calculating the sum of many values can often be a complex task. You can use the sum function in excel to ease up your task. In order to do so, go to the cell where you want the total value to appear and type “=SUM( and select all the cells you want to add up and press the “enter” key.

Step # 2 — Use the AutoSum function
Once done, go to the next cell and click on the “auto sum” button given under the “home” tab. Microsoft Excel will now automatically enter the formula here. In this manner, you can apply autosum in excel.

Step # 3 — Check the functions
You can choose to manually select the rows you want to sum up and press the “ctrl” key and tilde to check the functions. Now go to column B to add them and use the “auto sum” function.


Xem thêm bài viết khác:


  1. ❗ Subscribe To Our Main YouTube Channel

  2. Hello,
    I have a column mix of date and value, so how to sum the value? Ex: from row 1 to 4 is value but row 5 is date.

  3. My excel use to display the sum automatically just by highlighting an entire column. How do I get back to that?

  4. This is blurry nobody could see exactly what you're doing.

  5. Hi…..What is sum icon in ms excel .Would u plz help me

  6. Thanks I'll give it a thumbs up

  7. Can't see anything
    ever tried zooming in on your videos

  8. No matter what I do (including the directions in this video) the sum is only calculating the very last cell by itself and its driving me fucking crazy!!

  9. You go way to fast buddy..

  10. many thanks buddy! pretty informative video!

Leave a Reply

Your email address will not be published. Required fields are marked *