Excel SUM function

The SUM function is easier to use when you’re working with more than a few numbers or cells in a range. If you store such data as price lists or expense sheets in Excel, you may need a quick way to sum up prices or amounts. 

Most of the time, The SUM function in Microsoft Excel is used to add together a range of numbers or individual values. Here’s a quick guide on how to use it:

Examples:
If you want to sum the values in cells B1 through B8, you would use:

1. Click in the cell where you want the sum to appear
2. Type =SUM(

 

Now, type the formula =SUM(B1:B8) or select the range and press Enter to total the values in the cell

You have successfully calculated the sum of B1 to B8

 

Use AutoSum In MS Excel

You can quickly insert a SUM function by selecting clicking the AutoSum button (∑) on the Home tab.

1. Click in the cell where you want the sum to appear
2. Click AutoSum from the Home tab, in the Editing group.

Excel will automatically select the cell range it thinks you want to total.  This method is fast and lets you automatically get and keep the summing result in your table.

You can change the range if the automatically selected range is wrong. 

You can watch our video class at https://youtu.be/IvGUsw44yio

If you have any questions or difficulties, Please visit our forum tapgen.xyz. Be happy and excel in Excel!

=================================