Excel management - Using the Sum Function

Microsoft Excel gives you the ability to count up the total of a range of cells. The advantages behind doing this are easy to see. You might want to calculate the sum total of sales or of orders or of customer complaints about scams - there are an unlimited list of things you will want to use this for. This presentation is very helpful in this regard.

1. Excel Management: Part II How to Use the Sum Function

2. Why use the SUM Function? The values of adding cells and columns are too numerous to state here in this presentation. The simples reason is that you want to be able to count automatically without having to use a calculator and to go one by one counting up all the cells. This is because doing so will take you a lot of time and lead to incorrect results. Incorrect results lead towards scams and frauds when you charge customers incorrect amounts for items they purchase or other similar issues.

3. How to Implement This Function It is very simple. Let’s say you have a list of values from cell A2 – A9 – these all list the number of bills that your client has yet to pay you for. If you want the total to be calculate on A10 (or A11) go to that cell and type in the following: =SUM(A2:A9). Try it out and thank us later for this great tip!