Functions

Excel has Functions which assists with creating efficient formulas.

The Sum Function

Rather than entering in a formula such as =A2+A3+A4+A5+A6+A7+A8, a Sum function can be user per the above example.

The Sum function adds together a range. The range in the above example is A2 to A8.

Note: You can sum vertically by columns and you can also sum by rows.

The AutoSum Function

By clicking on the icon, you can automatically insert the sum function in the formula.

Other Functions

Other functions can be found by following Insert, Function.