## Figure 97 Use Calc to store numeric and statistical information

 Arial * 10 - 80^ - Jfc 2 = 1 A B c D E 1 Salesperson Units Price per Unit Revenue Rob Wittmaack 10 5 50 Derek Smith 23 5.45 125.35 Scott Douglass 105 6 630 Glare Dodds 65 5.75 373.75 Tom Denning 42 6 252 Darren Gratton 12 5 60 Steve Grigg 65 5 325 Avi Abadi 35 6 280 Nick Harvey 34 3.5 119 Rob Last 26 5.9 153.4 Jo Penny 12 8.4 100.8 Rachael Unsworth 10 2.6 26 Kim Holtham 36 3.4 122.4 Tim Weeks 34 5.9 200.6 Matt Bailey 21 5.3 111.3 Steve Hawkins 24 2.9 69.6 Damian Hughes 29 7.8 226.2

Calc's layout makes it easy to organize information into rows and columns. As you can see in the example, we have salespeople listed alongside the left column, customers in the second column, invoice date in the third column, and revenue in the fourth column. At the moment, no formulas are entered to help you interpret the data. Clicking the E21 cell selects it and allows you to enter in a formula in the top formula bar. If you enter in the equal sign, Calc knows that what you are entering is a formula and works accordingly.

In our example, we want to know the total revenue brought in up to now, so we need to enter in the formula =sum(E4:E20) and press Return. Calc automatically enters the result into cell E21. Now we want to see what the average order value was. To do this, we have to obtain how many orders there were. For this we can use the counta function to count the number of entries in a given list. This is usually used when you need to find out how many entries there are in a text list. So, in cell B21, enter =counta(B4:B20) and press Enter. Calc now counts the number of entries in the range and returns the total in B21. All that remains for us to do is divide the total revenue by the number of orders to find the average order value. So, in cell E22, enter the formula =E21/B21 to get the average order value.

0 0